Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Removing negative numbers/stop count a 0 for workday_diff formula

Topic Labels: Formulas
Solved
Jump to Solution
2293 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Millie_Symns
4 - Data Explorer
4 - Data Explorer

Hello!

I have a formula to count how many workdays are left between a data and “today” and when the reference data is “after today”, the output returns a negative number (as it should).

I am looking for a way to get my formula to only return “0” when that situation occurs. I haven’t figured out the nested if statement logic to make it work. Does anyone have a solution to this?

Thank you!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Without seeing your actual formula, sounds like you could just do the following:

MAX(0, *whatever your formula currently is*)

See Solution in Thread

3 Replies 3
Kamille_Parks
16 - Uranus
16 - Uranus

Without seeing your actual formula, sounds like you could just do the following:

MAX(0, *whatever your formula currently is*)

Yes, that works. Thank you!

This worked for me too - I had a weird situation where I was subtracting to find the remaining % and some (but not all) results were showing up as -0% - this extra nested MAX worked like a charm.

Michael_Kruse_0-1721849907558.png

So...THANKS Kamille!