Formula Support in Spotlight Web Reporting
  • 1 Minute to read
  • Dark
    Light
  • PDF

Formula Support in Spotlight Web Reporting

  • Dark
    Light
  • PDF

Article summary

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?