Formula for Net Margin problems

[Go-Anna]

This is my Net Margin Formula:

Net Margin = sum(aggr(((([Hourly Sales Rate]*[No of Charged Hours])-(([Wage Cost per Hour]+[Overhead Cost per Hour])*[No of Charged Hours]))/([Hourly Sales Rate]*[No of Charged Hours])),[Income Travel],[Hourly Sales Rate], Period,[Project Activity Nr and Name],[Project Nr and Name],[Cost Centre and Name]))

It works perfectly. The problem is that I need a Net Margin % 

Net Margin % =Net Margin/([Hourly Sales Rate]*[No of Charged Hours])

When I add this I get the correct %-age on the rows, but not as totals???

Why is this and what can I do?

[Nicole-Smith · Accepted solution]

You have no aggregation function around your denominator--if you add a sum() around it, the value will appear.  You will need to determine if the result is what you are expecting or not though.

[Go-Anna]

Thank you thank you thank you! YEEESSS! now its perfect 💃🙏