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