Hi, I also would suggest developer(s) find a way to make profit margin report rank accordingly rather than export to excel for formatting.
1 Like
What is your preferred rank?
Sometimes you may want to see the highest first for investment reasons and sometimes you may want to see the lowest first for divestment reasons. Other times, you might want to view an alphabetical list because it easier to sift through for specific items.
Profit margin of what? A business division, Customer, inventory item, Supplier?
How are you intending the profit margin to be calculated (exactly what is included)?
Imo the hard part is to calculate what is ment by profit margin. Sorting by that field then becomes trivial (copy report, paste into spreadsheet, sort by column).