Help

Could somebody help me? New Here

Topic Labels: Formulas
Solved
Jump to Solution
2896 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