I'm trying to make a simple calculation where IF a category field is set to "X" THEN return a specific number or text in a calculation field.
Eg. IF "employee status" = type A, THEN show "15%"
or IF "employee status" = type B, THEN show "150"
I tried various combinations of what I could find online here, but nothing that worked so far.
Please sign in to leave a comment.