Skip to Content
0

sorting group formula fields

Oct 26, 2016 at 01:06 PM

87

avatar image

hi @Abhilash KumarAbhilash Kumar;

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 left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Ghouse Baba Shaik Oct 26, 2016 at 02:21 PM
0

try this

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

=Abs(<your number>)

Share
10 |10000 characters needed characters left characters exceeded
Refeesh Aliyar Oct 27, 2016 at 06:54 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Refeesh Aliyar Nov 02, 2016 at 01:04 PM
0

ANY UPDATE

Share
10 |10000 characters needed characters left characters exceeded
Sastry Duvvuri Nov 02, 2016 at 02:09 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Refeesh Aliyar Nov 08, 2016 at 06:34 AM
0

@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

Share
10 |10000 characters needed characters left characters exceeded
Refeesh Aliyar Jan 29, 2017 at 12:23 PM
0

anybody can help??

Share
10 |10000 characters needed characters left characters exceeded