CALCULATE{"formula"} -- handle spreadsheet calculations outside tables
- The
%CALCULATE{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{$EXISTS(Web.SomeTopic)}%returns1if the topic exists -
%CALC{$UPPER(Collaboration)}%returnsCOLLABORATION
-
- Note: The CALCULATE variable is handled inside-out & left-to-right like ordinary TWiki variables, but it does not support functions that refer to table cells, such as
$LEFT()or$T(). Use CALC instead. - Category: DevelopmentVariables, TablesAndSpreadsheetsVariables
- Related: CALC, IF, IfStatements, SpreadSheetPlugin
r3 - 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.