Skip to Content
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



A111 432.2

A112 12.1

Total AAA 444.3


B111 50.5

B112 31.3

Total BBB 81.8


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']



But it sum for all values.

Can somebody help me as how do I complete this?

Thank in advance.