The Calculation properties allow you to change the settings for a specific calculation type. To reach them, locate the calculation type in the Calculation category of the Properties panel, and click Display calculation properties:
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8xMTAwLzMzMjkvY2tmaW5kZXIvaW1hZ2VzL2ltcG9ydC10eDVra2Z6YTY4NnEvaW1hZ2VzL2ljbi1jYWxjLXNldHRpbmdzLW5vcm1hbCgyKS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3NjcxNzUwNjB9fX1dfQ__&Signature=MNITBccFcHMTiP~nHhBsFNBBnKAFImeTtkiWtE4eC6TRTeaplL~RnjX9icKIIPqoorkjlTKO-2m5gpJZdJ6bhbJuFYmv-mXGqgGdyD1gNFeXeOITAfE2MTKEyU5gfPHoA23MIoUa9RrJ~CowUfzQ17lEg68yY4KzwangQiOBlN44CP8iomcL8Km~VXehXiHtn18~RGukgCquwHLMWBR98vtpnhKwQ0fNM1GpahvzbTy9lqpU2QWEhZ0knK0gsslvmYr9NAi9wypBcBuB7hzD4qWSerCKUJKQN1~F-QoG8BucqEjzzTSGZsGEODYHwp9HYdbC5NafxCfJOyOgkTNxpQ__&Key-Pair-Id=K2TK3EG287XSFC)
The properties are split into several categories. As usual with the properties panel, you can collapse and expand these categories. See the Overview of the properties panel for more information.
The available categories are as follows:
Common options for the calculation type. See common calculation properties for details.
Common options for total rows. See total rows and total columns.
Common options for total columns. See total rows and total columns.
Properties that allow you to define how the numbers in your calculation will be displayed. See number formatting.
Properties that allow you to apply ranking to the calculation being edited. See ranking.
Properties that allow you to add visual indicators or markers to your tables which can enhance the tables' legibility, according to the values being displayed. For example, you might want to display negative numbers in red. See conditional formatting.
Properties that allow you define how script calculations are calculated. See script.
In addition to the commands common throughout the properties panel, the toolbar contains the following command:
| Command name | Description |
|---|---|
|
Return to the main properties
|
Returns you to the main Properties panel. |