Computed Columns

[hussainac]

A report is created having columns A, B, C, D. Columns C & D are not direct data pulls from the DB, they have been created using count queries. I need to create a 3rd column E = D - C

Is there a mechanism to simply create a computed column from the front end interface by selecting 2 columns or currently it can only be done using a query?

[helicalforum]

Hello Hussainac,
we can achieve computation on columns using custom column in ad-hoc report from front end:
database used in this example is Mysql.

Create custom column and in the expression use:
“tablename.columnA - tablename.columnB”
Save the custom column.
The result set will be something as shown in the attached screenshot