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,