Hi
I am reconciling revenue for the month and need to calculate the growth amount for fees that have an uplift
For example our standard fee might be £350 and we charged an uplift fee of 40% which is £490. The growth amount is £140. On the spreadsheet the revenue amount is the total amount we have charged ie £490 so what formula can I use to calculate the growth amount?
The current formula is revenue amount X 40% which is technically incorrect