The
%CALCULATE{"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 uses the normal (left to right, inside out) Macro expansion order. If you need to evaluate after expanding table data, see
CALC
Examples
-
-
%CALCULATE{"$EXISTS(Web.SomeTopic)"}%
returns 1
if the topic exists
-
%CALCULATE{"$UPPER(Collaboration)"}%
returns COLLABORATION
CALC,
IF,
SpreadSheetPlugin