Running Balance for UNION report

Question

Dears,

I have a requirement to calculate running balances based on the open balance for UNION report.

The first UNION report is displaying the open balance and the second union is displaying transaction details, below is the sample format

Kindly advise how can I derive the running balance?

I really appreciate your help.

Jerry Casey · Answer

Try adding  "by 1" to the Max clause:  MAX(saw_1 by 1)+RSUM(ifnull(saw_2,0)).  I know it's a workaround, but the addition of a constant eliminates that error in most cases.

Avinash Pentyala · Answer

Yes, I've tried this option getting group by error.

NQS Error 59111 - The SQL statement must include group by clause.in Advanced tab, group by clause is available but that is enable for UNION report.

is there any way for this??

Jerry Casey · Answer

Are you familiar with the "Add Result Column" link on the combined analysis window? It allows you to create columns calculated outside the union.
 If your union looks like your example table, I would add a result column that looks like MAX(saw_1)+RSUM(ifnull(saw_2,0)).