Formula Support in Spotlight Web Reporting
- 1 Minute to read
- Print
- DarkLight
- PDF
Formula Support in Spotlight Web Reporting
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The user interface includes a formula bar above each report, which will display the formula for the selected cell.
You can view both excel type formulas and custom formulas in the bar.
For long formulas, the formula bar is expandable.
Note:
If the excel formula contains a reference to both row and column at once or a custom formula with a combination of the words RC, then the calculation doesn't work. For Example: =SUMIF($E$10:$E$13,"RC",I$10:I$13) is rendered as =SUMIF($E$10:$E$13,"T7",I$10:I$13).
Was this article helpful?