Math Functions and View Formula
- 1 Minute to read
- Print
- DarkLight
- PDF
Math Functions and View Formula
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Quick Math Functions
The View window includes a formula bar and quick functions such as Sum, Average, Count, Min, and Max. When you select a range of cells, the values in the quick functions update automatically.
View Formula Used for Calculation
You can view how a value at a particular cell intersection is being calculated by viewing the formula in the formula bar. For example, for all cell values that are derived using a calculation, you can view the formula associated with the calculation directly in the formula bar, while all cell values that do not have any calculation associated with them, you will see the respective cell values in the formula bar.
Note:
If the formula characters are more than 255, you must navigate to Model > Formula screen to view the complete formula.
How does the functionality work
Now, while you are working on any Report or View, the application constantly validates each cell intersection and verifies if any formula is defined within the calculation that is mapped to the artifact. For example, if your calculation contains formula, aggregation, map, or some other step, the application validates all these steps, finds the exact dimension intersection based on the scope, and then retrieves the formula and displays it in the formula bar
Note:
This functionality is available for preview in your Production environment if you opt in. Contact the Planful Support team to enable this functionality in Production.
How to Show Formulas in the Formula Bar?
- In Spotlight Web, Navigate to the Dynamic Planning > Analyze.
- Select a View and navigate to any cell intersection that has a calculation associated with it. Now you can view the formula in the formula bar.
Limitations
- If the Enable Save property is set to Yes and the Calculation on Save property is configured with a calculation, then the formula configured in the calculation will be displayed in the formula bar. For any other calculation where the Enable Save property is not set to Yes, then the formula will not be displayed.
- If the Enable Save property is set to Yes and the Calculation on Save property is configured with a calculation. Still, if the application runs a different calculation, then the formula displayed in the formula bar and the formula configured in the calculation will not match.
- If multiple formulas are configured for any intersection, then the application will display only one formula in the formula bar.
Was this article helpful?