CALC{"formula"} -- add spreadsheet calculations to tables
- The
%CALC{formula}%variable is handled by the SpreadSheetPlugin. Over 100 functions are available, 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
-
- Note: The CALC variable is handled with delay compared to other TWiki variables. You may get unexpected results if you nest CALC inside other variables (such as
%INCLUDE{%CALC{...}%}%) because it does not get evaluated inside-out & left-to-right like ordinary TWiki variables. Use CALCULATE if you nest variables. - Category: DevelopmentVariables, TablesAndSpreadsheetsVariables
- Related: CALCULATE, IF, IfStatements, SpreadSheetPlugin
r6 - 23 Mar 2013 - 08:16:51 - TWikiContributor
TWiki
TWiki Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
Linux4SAM
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Microchip and others, are registered trademarks or trademarks of Microchip Technology Inc. and its subsidiaries. 
Arm® and others are registered trademarks or trademarks of Arm Limited (or its affiliates). Other terms and product names may be trademarks of others.
Ideas, requests, contributions ? Connect to LinksToCommunities page.