I want to simplify one of my reports that has multiple sub queries that calculate some of the column values. I need to add the results of two columns (queries) as well as display the results in their normal column, say columns 3 and 4 with the addition of column 3 and 4 values displayed in column 5.
I am at present duplicating the sql of both columns for the third with a + sign joining them. This works fine but I am sure that there is a better way of doing this.
Possibly by storing the original two sub query results into two individual variables and then adding these variables to give the value required for column 5.
I cannot find any examples of how to do this in my reference books and would be grateful for any assistance.
Thank you for your time. Regards Allan Godney