SuperTables
WebsiteAll products
V4.0
V4.0
  • SuperTables
  • Getting Started
    • Installation
    • Quick Start Guide
      • Setting Up SuperTables In a Dashboard
      • Setting up SuperTables as a Viz extension
    • UI Explained
      • UI Overview
      • Pivot
      • Formulas
      • Row Groupings
      • Status Bar
  • Features
    • Inline Filter
    • Advanced Filter
    • Grouping
    • Column Order
    • Hiding a column
    • Sorting Columns
    • Column Pane
    • Filter Pane
    • Row Groups
    • Autosize Columns
    • Context Menu
      • Cell Features
      • Copy With Headers
      • Clear All Filters
      • Export to PDF
      • Export to Excel & CSV
    • Pivot Your Table
    • Dynamic Aggregation
    • Formulas
  • Configuration Screen
    • General Tab
    • Data Tab
      • Create Alias
      • Data Fetch Method
      • Dimension Data Pane
        • Dimension Format
        • Column Background Color
        • Dimension Properties
      • Measure Data Pane
        • Measure Format
        • Measure Properties
      • Calculations Pane
      • Column Groups Pane
    • Actions Tab
    • Appearance Tab
      • Multiple Layouts
      • Custom Views
      • Charting
      • Layout Options
      • Grouping Options
      • Pivoting options
      • Accessibility
    • Theme Tab
    • Restrictions Tab
    • Tooltip Tab
    • Export Tab
    • About Tab
  • Enterprise Only Functionality
    • Custom Themes (Enterprise Only)
    • Custom Events (Enterprise Only)
    • Localization (Enterprise Only)
    • Export Pictures In Excel (Enterprise Only)
  • Guides
    • Setting up Calculations
      • Setting up a Simple Calculation
      • If-Else Calculation
      • Absolute Function
    • Conditionally coloring column(s)
    • How to make tool tips
    • Setting up Selective Aggregation
  • Accessibility FAQ
  • Support
  • Appendices
    • Glossary
    • Change log
Powered by GitBook
On this page
  1. Features

Formulas

PreviousDynamic AggregationNextConfiguration Screen

Last updated 9 months ago

This section describes the formulas available to users for on-the-fly data analysis. The formula editor allows end users to add formula-based columns to their SuperTables view using the measures and dimensions available to them.

Formatting options

Formulas can be formatted as a decimal number, currency or percentage. The amount of decimals can be edited, as well as the pre-and-suffix appended to the calculated measure.

IF/ELSE configuration

Using the If-Else Formula Editor, advanced formulas can be created using conditions for both strings and values. Set the “if” statement, calculations for when the condition is and isn’t met, and potential other “if” statements using additional “else-if” blocks. Advanced conditions using AND/OR clauses can also be set in these formulas.

To learn more about how to create formulas, read the .

guide on calculations