Add a calculation
User permission: Manage Custom Statements
The calculations you see on the Edit statement tab of the Manage statements screen display as white rows in the statement grid.
Calculations can be basic formulas that refer to groups or other calculations in the statement. They can also be more complex formulas that include functions, used to calculate financial ratios (such as Days in Period), refer to statistical streams, and include groups from Balance Sheets.
You can add new calculations, edit existing calculations and delete calculations you no longer need.
For example, suppose you want to view the gross profit margin in your Profit and Loss statement. You can achieve this by adding a calculation.
Add a calculation to a statement
Click the Add button where you want to insert the new calculation and select Calculation. Alternatively, click an item's menu button (three dots), then select Insert row above or Insert row below, and select Calculation.
Enter a name for the calculation.
Enter the calculation formula:
Click in the calculation box to activate it.
Enter mathematical symbols and reference to other items in the statement to build your formula. To refer to a group or calculation, click that item's colored button to automatically insert it into the formula.
Use the inbuilt functions and standard financial ratio formulas as required.
Change the default format of the calculation result, if required. You can select from a list of default formatting options or create your own custom formatting.
Edit its Style settings as required.
Watch these other videos:
Phocas Demo: Financial ratios
PUG Training: Ratios and statistical streams
Add a calculation to a dashboard
Just like the other rows in a financial statement, you can add calculations to your dashboard. They can be in the grid view or chart. This is a handy way to keep track of KPIs and other ratios.
Last updated