Nedd help on sum

[rb2005]

Hi,
I am trying to do

formula3= formula1 + sum(formula2)

sum cases this is working but sum cases not. I have few groups. I am displaying formula1 in group header and formula2 in detail section.
Let say I have grp1,grp2,grp3,grp4
Now let say group4 has 4 item A,B,C,D
formula1=0 for A, Formula1 =25 for B, Formula1 = 30 for C and Formula1 =50 for D
if formula1 or sum(formula2)=0 then formula3 is not working.
But if I am doing like sum(formula1)+sum(formula2)=formula3
then it fails if either one is non zero.

Any one has any clue?

 

[lbass]

What is your group field? What is the content of formula1? What is the content of formula2? What do you mean by formula3 failing? Incorrect figures? Returns a null?

-LB

 

[rb2005]

formula one is numaric, formula2 is numeric. Formula3 = formula1 + sum(formula2)

Formula3 is sometime returning formula1+sum(formula2). sometime only sum(formula2). If formula=0 or sum(formula2) = 0 then only it fails. It always returning some value not null. Some how the addition is not working properly. I have formula3 in group footer.
RB

 

[lbass]

You must share the contents of your formulas.

-LB