Calculated Columns/Rows is a Layout Asset option that allows users to add additional columns/rows into the report and then enter a calculation using the data to create a new figure.  

The calculation bar allows users to enter a myriad of calculations quickly and easily. As for Percentages and Totals  - there are a number of settings that can apply. Some are in Calculations under the Settings button and some are found in a right click menu in Layout Assets or the Report Grid. (See Calculated Column/row settings for more information)

 

Where do I find Calculated Columns/Rows to add into an AQX 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 Settings 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.

 

Example: this calculated column adds Metropolitan TV to Regional TV

 

 

Renaming a Calculated Column/Row  Header

AQX 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.

e.g. The calculated column below is an addition of Metropolitan Television and Regional television to give one total figure for TV - therefore I have renamed the column header to be TOTAL TV.

 

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.