TWiki WebCALC{"formula"} -- add spreadsheet calculations to tables and outside tables
- The
%CALC{"formula"}%variable is handled by the SpreadSheetPlugin. There are around 80 formulae, such as$ABS(),$EXACT(),$EXISTS(),$GET()/$SET(),$IF(),$LOG(),$LOWER(),$PERCENTILE(),$TIME(),$VALUE(). - Syntax:
%CALC{"formula"}% - Examples:
-
%CALC{"$SUM($ABOVE())"}%returns the sum of all cells above the current cell -
%CALC{"$EXISTS(Web.SomeTopic)"}%returns1if the topic exists -
%CALC{"$UPPER(Collaboration)"}%returnsCOLLABORATION
-
- Related: IF, SpreadSheetPlugin
About This Site
Please note that this site is a content mirror of the BNL USATLAS TWiki. To edit the content of this page, click the Edit this page button at the top of the page and log in with your BNL USATLAS account.
Attachments
TWiki Web
Users
Groups
Index
Search
Changes
Notifications
Statistics
Preferences
Admins |
|
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback
Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.VarCALC