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. Guides
  2. Setting up Calculations

If-Else Calculation

PreviousSetting up a Simple CalculationNextAbsolute Function

Last updated 9 months ago

Step 1: Open Configuration

This can be done by clicking your the container that has super tables on your dashboard.

Step 2: Navigate to the Data tab

Step 3: Make a Calculation Column

On the left side of the data tab. There is pane that says calculation. Click make a calculation on there.

Step 4: Navigate to the Calculation Box

Navigate to the box that contains Calculation. Depending on your screen size you may have to scroll down.

Step 5: Open If-Else Formulas Editor

To access the if Else Formula Editor, Click on the If-Else Formula Editor.

Step 6: Create your Calculation

In this case we will create a calculation that will display 0 if profit is lower than or equal to 0 but otherwise it will display the profit value.

Click save and Apply & Close.