Hello:
Scenario
I have a client with an Income Statement that calulates the percentage of revenue in column B. It currently calculates the percentage by dividing the value by the Total Revenue.
Example: COGS for the Golf Course Department is divided by the Total Revenue.
The dilema I'm experiencing is that my client wants to divide the value by the corresponding department revenue.
Example: COGS for the Golf Course Department divided by the Golf Department Revenue.
I have been unable to come up with a formula or way to allow for this. Is this even possible with FRx?
Any suggestions are welcome.
Kind regards,
Todd M Bowlsby