head	1.2;
access;
symbols;
locks; strict;
comment	@# @;


1.2
date	2012.11.12.06.58.17;	author TWikiContributor;	state Exp;
branches;
next	1.1;

1.1
date	2012.10.07.08.00.56;	author TWikiContributor;	state Exp;
branches;
next	;


desc
@buildrelease
@


1.2
log
@buildrelease
@
text
@%META:TOPICINFO{author="TWikiContributor" date="1352703497" format="1.1" version="2"}%
%META:TOPICPARENT{name="TWikiVariables"}%
#VarCALCULATE
---+++ CALCULATE{"formula"} -- handle spreadsheet calculations outside tables
   * The =%<nop>CALCULATE{formula}%= variable is handled by the SpreadSheetPlugin. Around 100 functions are available, such as =$ABS()=, =$EXACT()=, =$EXISTS()=, =$GET()/$SET()=, =$IF()=, =$LOG()=, =$LOWER()=, =$PERCENTILE()=, =$TIME()=, =$VALUE()=.
   * Syntax: =%<nop>CALC{formula}%=
   * Examples:
      * =%<nop>CALC{$EXISTS(<nop>Web.SomeTopic)}%= returns =1= if the topic exists
      * =%<nop>CALC{$UPPER(Collaboration)}%= returns =COLLABORATION=
   * Note: The CALCULATE variable is handled inside-out &amp; left-to-right like ordinary TWiki variables, but it does __not__ support functions that refer to table cells, such as =$LEFT()= or =$T()=. Use [[%IF{"'%INCLUDINGTOPIC%'='TWikiVariables'" then="#"}%VarCALC][CALC]] instead.
   * Category: DevelopmentVariables, TablesAndSpreadsheetsVariables
   * Related: [[%IF{"'%INCLUDINGTOPIC%'='TWikiVariables'" then="#"}%VarCALC][CALC]], [[%IF{"'%INCLUDINGTOPIC%'='TWikiVariables'" then="#"}%VarIF][IF]], %SYSTEMWEB%.IfStatements, SpreadSheetPlugin
@


1.1
log
@buildrelease
@
text
@d1 1
a1 1
%META:TOPICINFO{author="TWikiContributor" date="1341041148" format="1.1" version="1"}%
d10 2
a11 1
   * __Note:__ The CALCULATE variable is handled inside-out &amp; left-to-right like ordinary TWiki variables, but it does __not__ support functions that refer to table cells, such as =$LEFT()= or =$T()=. Use [[%IF{"'%INCLUDINGTOPIC%'='TWikiVariables'" then="#"}%VarCALC][CALC]] instead.
@
