hi Ghouse Baba Shaik; i already applied this method and checked but the values are not matching because it carry foreword the negative to positive from "detail" section and resulting a wrong value. its not applicable in this case if i made formula in group level i cannot sum it up.
Hi,
In detail level, use this formula and then sum it up.
If {valuefield} <0 then {valuefield}*-1 else {valuefield}
Sum the the results of this formula at group level then go in Report-- Group sort expert-- define Top N as 200000 (based on your maximum record count) and select the summary.
This will convert all your numbers in positive and sort.
Thanks,
Sastry
@Sastry Duvvuri: the detail level i cannot give this formula because the value is accumalating as a huge amount. this correct formula can apply only in grouplevel as i mentioned on top. i need something in grouplevel without calculation from detail level
Add comment