Referencing a formula field from another formula field

Referencing a formula field from another formula field

I am new to Zoho, and building my first app to calculate sales commissions. I understand from other posts and the user guide that you can't reference a formula field in another formula field. However, I need a way to do the following, which I'm sure there is a script or other work-around to do:

  1. Revenue (Currency Field)
  2. Overhead % (Percent Field)
  3. Overhead Rate (Formula Field) = Revenue * Overhead %

All of the above works fine. However, I can't figure out how to do the following:

  1. Net Margin = Revenue - Overhead Rate

I don't necessarily need to save "Net Margin" as a field, but I would like to show it on a report if there is a way to calculate it in the report.