Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Could somebody help me? New Here

Topic Labels: Formulas
Solved
Jump to Solution
3541 2
cancel
Showing results for 
Search instead for 
Did you mean: 
THE_GOLDEN_SUIT
4 - Data Explorer
4 - Data Explorer

Screenshot 2020-07-08 at 00.41.51

I have data being automatically being inputted from Stripe to the column on the right.
I need to -2 from the number in the right column and then *87 however I don’t want it to go minus(it does this when there’s no data in the right column). I want 0 to be lowest value it goes.

Could somebody help? ( new to all this…!)

Cheers! :grinning_face_with_big_eyes:

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

I think you could use something like this:

MAX(
   {Stripe Next Sequ...} - 2,
   0
) * 87

That way, if {Stripe Next Sequ...} results in a number less than 0, this field will multiply 0 * 87 instead of the negative number.

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

I think you could use something like this:

MAX(
   {Stripe Next Sequ...} - 2,
   0
) * 87

That way, if {Stripe Next Sequ...} results in a number less than 0, this field will multiply 0 * 87 instead of the negative number.

Thank you this worked perfectly! Appreciate the help :grinning_face_with_big_eyes:

Legend