Salesforce Docs Portal

Use Case 5: Calculate Revenue

This use case calculates revenue by a defined margin.

Raw Data Goal
Column named Revenue. Create the formula field “Revenue Plus Margin” and add a 5% margin to the revenue.
  1. For Field Label, enter Revenue Plus Margin.
  2. For Formula Return Type, select Number.
  3. In the syntax editor, enter the formula: sourceField[‘Revenue’]*1.05.
  4. In the test input box, validate the formula using this combination.
    • “Revenue” with the value of “10” returns “10.5”.
  5. Click Save.
  6. Verify that “Revenue Plus Margin” is added as a field.