You are here:
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. |
- For Field Label, enter Revenue Plus Margin.
- For Formula Return Type, select Number.
- In the syntax editor, enter the formula: sourceField[‘Revenue’]*1.05.
- In the test input box, validate the formula using this combination.
- “Revenue” with the value of “10” returns “10.5”.
- Click Save.
- Verify that “Revenue Plus Margin” is added as a field.

