
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 07, 2020 04:45 PM
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:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 07, 2020 04:55 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 07, 2020 04:55 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 08, 2020 01:45 AM
Thank you this worked perfectly! Appreciate the help :grinning_face_with_big_eyes:
Legend
