I promise I will only have 3 or 4 more questions today...
What I am using:
IF [New age] = "" THEN "0" ELSEIF [New age] > "44" THEN "2" ELSE "1" ENDIF
In English this is what I am trying to accomplish- If the [New age] field is blank, I either want to move a "0" to the new field [formula age] or just move the blank. Whichever is easier. If [New age] is greater than 44, move a 2 to the new field, and finally, if it is less than 44 move a 1.
The problem is it codes a 1 for all of the blanks. I think I understand why it is doing that, I just don't know how to fix it. It is doing great on those 2 codes, but the 1s are giving me fits.
Solved! Go to Solution.
Hi @tpostlewate,
Can you try this?
IF IsEmpty([New Age]) THEN "0" ELSEIF [New age] > "44" THEN "2" ELSE "1" ENDIF
I think this part might be problematic: [New age] = ""
Brilliant! Worked perfectly! 🙂