 |
|
You are here: CMS Wiki>System Web>Category>UserDocumentationCategory>Macros>VarCALC (2022-03-28, UnknownUser)Edit Attach
CALC -- add spreadsheet calculations to tables and outside tables
The%CALC{"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 specifically for manipulating data in tables, and so is evaluated after the normal Macro expansion order. If you need a standard ordered evaluation see CALCULATE
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
CALCULATE, IF, SpreadSheetPluginEdit | Attach | Print version | History: r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r1 - 2022-03-28, UnknownUser
- User Reference
- BeginnersStartHere
- EditingShorthand
- Macros
- MacrosQuickReference
- FormattedSearch
- QuerySearch
- DocumentGraphics
- SkinBrowser
- InstalledPlugins
- Admin Maintenance
- Reference Manual
- AdminToolsCategory
- InterWikis
- ManagingWebs
- SiteTools
- DefaultPreferences
- WebPreferences
- Categories
- AdminDocumentationCategory
- AdminToolsCategory
- DeveloperDocumentationCategory
- UserDocumentationCategory
- UserToolsCategory
- Webs
-
CMSUserHelp
- Main
- Sandbox
- SysAdmin
- System
Copyright &© by the contributing authors. All material on this site is the property of the contributing authors. Ideas, requests, problems regarding CMS Wiki? Send feedback