As of 11 Oct 2025, the Performance Measurement Network has been upgraded. If you experience any problems with the site, please report them to Wiki Webmaster.
Log in
Go to Joint Commission

System

You are here:

CALC -- add spreadsheet calculations to tables and outside tables

26 August 2025 - 17:41 | Version 1 |
The %CALC{"formula"}% macro is handled by the SpreadSheetPlugin. There are around 90 formulae, such as $ABS(), $EXACT(), $EXISTS(), $GET()/$SET(), $IF(), $LOG(), $LOWER(), $PERCENTILE(), $TIME(), $VALUE().
  • This macro is specifically for manipulating data in tables, and so is evaluated after the normal Macro expansion order. If you need a standard ordered evaluation see CALCULATE

Examples

  • %CALC{"$SUM($ABOVE())"}% returns the sum of all cells above the current cell
  • %CALC{"$EXISTS(Web.SomeTopic)"}% returns 1 if the topic exists
  • %CALC{"$UPPER(Collaboration)"}% returns COLLABORATION

This site is powered by FoswikiCopyright © by the contributing authors. All material on this site is the property of the contributing authors.
Ideas, requests, problems regarding Performance Measurement Network? Send feedback
This website is using cookies. More info. That's Fine