This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
