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.
.png?sv=2022-11-02&spr=https&st=2025-11-04T14%3A34%3A54Z&se=2025-11-04T14%3A44%3A54Z&sr=c&sp=r&sig=rdSVCJDdjXZzDbWIV8gfyYeK3LOJQY1qogGsr2JMSmM%3D)
.png?sv=2022-11-02&spr=https&st=2025-11-04T14%3A34%3A54Z&se=2025-11-04T14%3A44%3A54Z&sr=c&sp=r&sig=rdSVCJDdjXZzDbWIV8gfyYeK3LOJQY1qogGsr2JMSmM%3D)
For long formulas, the formula bar is expandable.
.png?sv=2022-11-02&spr=https&st=2025-11-04T14%3A34%3A54Z&se=2025-11-04T14%3A44%3A54Z&sr=c&sp=r&sig=rdSVCJDdjXZzDbWIV8gfyYeK3LOJQY1qogGsr2JMSmM%3D)
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?