Help

Grouping percents for tracking margin

Topic Labels: Formulas
Solved
Jump to Solution
1518 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Holli_Younger
8 - Airtable Astronomer
8 - Airtable Astronomer

Not sure how to title this, too early to think of the proper name - but this is what I’m trying to accomplish and I can get one percent to work but the others fill in with Error or NaN.

When Gross Profit percent is:

0%:
Formula is:
0%

gross profit: 1-15% formula reads: 1-15%
16-25%…
26-45%…
and so on up to 100%

Trying to group all gross profits based on the percent for graphing purposes.

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Is this what you’re looking for?

53%20PM

Here’s the formula in the {Range} field. I only added the first three levels (0%, 1-15%, 16-25%), but the others should be easy to add following the same pattern.

IF({Gross Profit} < .01, "0%",
IF({Gross Profit} <= .15, "1-15%",
IF({Gross Profit} <= .25, "16-25%")))

See Solution in Thread

3 Replies 3
Holli_Younger
8 - Airtable Astronomer
8 - Airtable Astronomer

I’d also like to know how to remove the Nan/Error if blank as these totals have not been figured yet. Not sure if the formula I was using is not working because the issues I was having with the previous formula.

Justin_Barrett
18 - Pluto
18 - Pluto

Is this what you’re looking for?

53%20PM

Here’s the formula in the {Range} field. I only added the first three levels (0%, 1-15%, 16-25%), but the others should be easy to add following the same pattern.

IF({Gross Profit} < .01, "0%",
IF({Gross Profit} <= .15, "1-15%",
IF({Gross Profit} <= .25, "16-25%")))
Holli_Younger
8 - Airtable Astronomer
8 - Airtable Astronomer

Exactly what I was needing @Justin_Barrett. I was putting the percents as a percent and not decimal. Thanks for the example.