eTAM Manual
How to add Calculated Columns/Rows
Fusion Elements > Report Tab > Report Workspace > Report Options > Adding Calculations to a Report Layout > How to add Calculated Columns/Rows

 

Where do I find Calculated Columns/Rows to add into an report?

Calculated Columns/Rows can be found under Calculations at the bottom of the tree in the Layout Asset Slider bar. They can be dragged on or off a report as required.  There are settings for Calculated Columns/Rows that can be made before or after moving them into a report. Please see Calculated Column/Row for more information

 

Adding a Calculated Column/Row into a report

To add a calculated Column or row into a report, check your settings to ensure they are set up as required then:

  1. Click on Calculated Columns/Rows in Layout Assets and drag to the location in the report you require. A grey line will indicated where in the grid you are - the orange highlighted cell will indicate which cell it will be placed in front or behind of and a green cross will indicated if it is a valid location.

  2. Once you've dropped the item into the grid a calculation bar will appear above. Enter in your calculation by clicking on the column/row headers and entering any other formula information as required using your keyboard. The name of the cell header clicked on will appear in the calculation bar in a colour which will also border the cell in the grid. Each cell will have a different colour.

  3. Click OK.

 

Renaming a Calculated Column/Row  Header

Fusion will by default set the Calculated Columns/Rows Header as 'Calc Col/row' and a number which will increase by one each time another calculation is added into that report grid.

For example, the first calculated column/row will be 'Calc col/row1', the second one will be 'Calc col/row2' etc. However you can rename a header to better reflect what the calculation is showing.

To do so:

  1. Click on the header, pause, then click once more to get focus on the cell (don't double click - the text will be highlighted blue when it works), then
  2. Type in the name required.

In the below example, the calculated column  is and addition of 7TWO and 7Mate to give a digital total, therefore the Calculated Row was named "Digital Total"

 

How to Hide the data and show only the Calculated column figure

AQX allows you to show only the calculated column figure if required and hide the data the figure is based on. To do so:

  1. First add the calculated column/s to the report
  2. Then right click anywhere in the report layout and select Hide data

This will then hide the data and leave the Calculated columns only on screen. This can be done either before or after the report has been run.