Skip to Content
0
May 13, 2018 at 11:28 AM

Net Total that will add up "Total AAA + Total BBB"

109 Views Last edit May 21, 2018 at 05:55 AM 2 rev

Hello Gurus,

I'm using crystal report XI. I'm trying to calculate the value for some groups only, so for example, I have group lay down as follow

CurMon

AAA

A111 432.2

A112 12.1

Total AAA 444.3

BBB

B111 50.5

B112 31.3

Total BBB 81.8

CCC

C111 60.2

C112 21.1

Total CCC 81.3

I have more groups and subgroups like this. Now I want a "Net Total" that will add up "Total AAA + Total BBB" So it should display as follow,right below the "Total BBB"

Net Total : 526.1

I tried with formula like

If Group1 in ['AAA','BBB']

Then

Sum{CurMon}

But it sum for all values.

Can somebody help me as how do I complete this?

Thank in advance.