Tips and Tricks

Sum Multiple Colmns

Description

A virtual column allows you to create a new column based off of a combination of fields that already exist. For example, you want to sum the amount in multiple fields and display that sum as a new column. Virtual Columns can be used to create columns where a formula may be required, such as: Total = Column A + Column B + Column C. Or they may also be used to combine or concatenate two columns into one, such as: New Column = (Name, Position Title) To create a virtual column: 1. Click the settings gear button above the report results 2. Click Add Virtual Column from the drop-down 3. Populate the Virtual Column worksheet and complete all necessary fields

Related Videos

FAST is completely customizable,
easy to set up, and fully integrated.

Let's Talk
100% web-based platform
No client software to install
Remote implementation
Deploy in hours