Hello,
I’m trying to do a fairly basic calculation that is conditional on a percentage field - if the percent is above a threshold, return a calculated number, if below return 0. My formula works with anything except zero for value 2.
Here’s my formu...
Yeah, sorry about that - first time didnt show as being a reply to your post, so I thought I’d better retry.
Will look again and see if the formula can be fixed based on your suggestions.
Thanks.
Phil_Vallender:
Hey! Sorry, by ‘value 2’ I mean the return value from the IF state when false.
When false, I want the IF statement to simply return 0 (as a number).
Hey! Sorry, by ‘value 2’ I mean the return value from the IF state when false....
Here’s my formula:
The red squiggle error says missing parenthesis (but adding doesnt seem to fix).
Basically the formula seems to work when both return Value 1 and Value 2 are either text or other fields, but as soon as I enter 0, all results go to...
