Friends I have data this way
Gh1
WHOLE total-----2
GH2
ZZ total--- 1
details
abc 1
abc 0
GH2
SS total---0
details
abc 0
abc 0
GH2
CO total---1
details
abc 1
abc 1
But in GH 1 when i do sum it summing up every detail and giving me value 3. Is there a formula I can use to display it as 2?
Thanks in advance,
Vega.
Gh1
WHOLE total-----2
GH2
ZZ total--- 1
details
abc 1
abc 0
GH2
SS total---0
details
abc 0
abc 0
GH2
CO total---1
details
abc 1
abc 1
But in GH 1 when i do sum it summing up every detail and giving me value 3. Is there a formula I can use to display it as 2?
Thanks in advance,
Vega.