Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 18, 2023 08:02 AM - edited Feb 18, 2023 09:03 AM
Hello Airtable Community! 🙂
So... I am rather new. I have a formula that works fine, except that occassionally the result is a negative number.
How can I display the result as "ZERO" if the result is less than zero (i.e. a negative number)?
I read somewhere that MAX should do the trick... but not working.
IF({Total Sold}> 0, MAX({Total Sold}-({Products Completed}+{Total qty on hand})), 0)
P.S. As mentioned, I am new, so if you do write out a quick formula, could you please use MY actual field names? 🙂
please advise, and thank you in advance!
DJ
Solved! Go to Solution.
Feb 18, 2023 09:20 AM
I am very torn about writing this reply. You asked that replies use your actual field names. However, I am on a mobile device and trying to write out your actual field names is very difficult. This platform makes it very difficult to copy/paste text and I cannot see your post when typing my reply. So my choices are to not reply at all, or to reply without using your field names.
It looks like you are not nesting the 0 inside the MAX() formula. Instead, the zero is the third parameter of your IF() and is shown when there isn’t any total sold. In order to get the MAX() to work, you need to pot the comma and zero inside the closing parentheses for the MAX() function.
MAX( {your calculation}, 0)
Feb 18, 2023 09:20 AM
I am very torn about writing this reply. You asked that replies use your actual field names. However, I am on a mobile device and trying to write out your actual field names is very difficult. This platform makes it very difficult to copy/paste text and I cannot see your post when typing my reply. So my choices are to not reply at all, or to reply without using your field names.
It looks like you are not nesting the 0 inside the MAX() formula. Instead, the zero is the third parameter of your IF() and is shown when there isn’t any total sold. In order to get the MAX() to work, you need to pot the comma and zero inside the closing parentheses for the MAX() function.
MAX( {your calculation}, 0)
Feb 18, 2023 09:33 AM
Ahhhhh! that worked! 🙂 Thank you, Kuovonne! 😀