We have the need to perform some calculations on a table to generate a result.
CellA * Cell B = NewValue to display
CellA / Cell B = New Value to display
Is there a way to perform this in a dashboard using GQI or other method?
The other requirement is that the result is part of the export to csv when selected or scheduled.
Expanding on the answer above, our user needed to use an elements parameter lookup and a custom property value for the calculation. We put together the attached automation script 'CustomProperty-DivideColumns.xml' which creates a Custom Operator called 'CustomProperty-DivideColumns'. This then prompts the user for the Dividend Column / Divisor Column = New Column Name (Quotient).
CustomProperty-DivideColumns.xml
Results table:
