I'm trying to get a calculated field to create a value (1) given a few separate conditions.
ELSEIF [ US]>30
Currently the calculated field is only giving me results for the second segment. Any insight as to why this isn't working or solutions would be greatly appreciated.
I am imagining you copied this formula from Tableau, in that case do you have two different [US] fields? The first one does not have a space and the second one does.
[US] vs [ US]
If that is not it, are you able to attach a sample workbook for a deeper look?