CALC -- add spreadsheet calculations to tables and outside tables
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
CALCULATE,
IF,
SpreadSheetPlugin