Calculating Markup Percentage is Returning a Negative Percentage

[CottageKeeper]

In the MP IMU% field I have this formula:

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

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:

[augmented · Accepted solution]

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.

[CottageKeeper]

@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: