Skip to Content
0
Former Member
Feb 25, 2009 at 12:23 PM

Formula Not working Perfectly

30 Views

Hi,

I have a senario wherr i have to find out +ve and -ve values from total.

I had put formula (total>=0)total and (total<=0)total that gives me the +ve and -ve values. Here Total itself is a formula of two selections in the stucture. Now when i am running the report it shows three colums +ve -ve and total.

Now if 4 records are there with value 1,-3,2,-2 then out put in respective colums should be 12 =3 and -3-2 =-5 and total = -2.

Instead of this i am getting 0 -2 -2 because it first aggregated the records and then applying the formula.

Can any one help me to get the desired reasult.

Regards,