Hi,
I have a question regarding calculation of a select one question. Imagine a simple Yes - No select_one question.
My calculation field currently looks like this:
if(${value} >=10,'yes',null)
Current behavior if value is above 10:
"Yes" is selected.
Current behavior if value is under10:
There is no choice selected
So far so good. Now if the value is under 10 and I select either "Yes" or "No", I see the green "refresh arrows" on the right. I don't want that. What I am trying to achieve if for the green arrow to be displayed only if the calculation resulted in the "Yes" selection. Basicly, what I would like is this:
-If value is >= 10, then do a calculation
-Else do not calculate the field at all (so that I don't see the green arrows if I make a choice)
Is it possible to do that?
I tried to do this with the "Null" in the If statement, but it didn't work.
Thank you for your time
Hi Nicolas,
The if() function does not have the ability to only calculate if true; it must calculate the false value as well. A null keyword will not prevent calculation.