Former Member

sorting group formula fields

we are discussing and solving the issue for above said subject .kindly click the link for more information(https://archive.sap.com/discussions/thread/3913362), unfortunately i cannot reply on archived Q&A that's what i am writing new section.

based on your last answer from you i tried in my system. the value is coming current and when i am going for group sort the negatives are coming down and positive values are on top. basically what i need is regardless of positive or negative i need all the values to be positive and that values need to come together in sort order as example below

Proposed Plan created by excel with crystal report data

current output

based on your formula eighter i can sort -ve or +ve

hope you can help me

10|10000 characters needed characters exceeded

• Former Member
Oct 26, 2016 at 02:21 PM

try this

create a new variable using below formula, pull in to the report apply sort on new available and hide it

10|10000 characters needed characters exceeded
• Former Member
Oct 27, 2016 at 06:54 AM

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.

10|10000 characters needed characters exceeded
• Former Member
Nov 02, 2016 at 01:04 PM

ANY UPDATE

10|10000 characters needed characters exceeded
• Former Member
Nov 02, 2016 at 02:09 PM

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

10|10000 characters needed characters exceeded
• Former Member
Nov 08, 2016 at 06:34 AM

@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