Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Calculating Markup Percentage is Returning a Negative Percentage

Topic Labels: Formulas
Solved
Jump to Solution
477 2
cancel
Showing results for 
Search instead for 
Did you mean: 

In the MP IMU% field I have this formula:

IF({MP ICOGS},SUM({MP IGP} / {MP ICOGS}))

Screen Shot 2021-02-11 at 5.34.58 PM

My question is how do I change my formula to return a value in the MP IMU% field that is not a negative percentage? The true answer is 281.34% - I’m beyond stumped??? :woozy_face:

1 Solution

Accepted Solutions

Hi! Your {MP ICOGS} value is negative. I hate to even say that “a positive number divided by a negative number is a negative number”. Whoops!

To turn the tables on that negative value, use ABS({MP ICOGS}) or ABS({MP IGP}/{MP ICOGS}). Hope this is what you’re going for.

Or you can fix your {MP ICOGS} field formula to return a positive value. If “ICOGS” stands for something cost of goods sold, then it probably is a positive number in reality.

See Solution in Thread

2 Replies 2

Hi! Your {MP ICOGS} value is negative. I hate to even say that “a positive number divided by a negative number is a negative number”. Whoops!

To turn the tables on that negative value, use ABS({MP ICOGS}) or ABS({MP IGP}/{MP ICOGS}). Hope this is what you’re going for.

Or you can fix your {MP ICOGS} field formula to return a positive value. If “ICOGS” stands for something cost of goods sold, then it probably is a positive number in reality.

@augmented Thank you!

IF({MP ICOGS}, ABS({MP IGP}/{MP ICOGS}))
This worked!

COGS are actually expenses therefore they are entered as a negative number. All the income fields are entered as positive currency. Excel makes this easy but not so much in Airtable.

Many thanks!!! :pray: :grinning: :high_brightness: