on 06-01-2016 1:45 PM
hi,
i am using crystal report for my business purpose. now i created a report and my team need to make a value as (ABS) to make it all +ve value. for that i made a formula but when i use this formula for my report i cannot sort using group sort expert because it is a formula i created for that group.
kindly advice me how can i do it .your early action is appreciated.
hi Former Member: i been used abs then only i got the positive values. its working fine in my report.you can review the attached picture.
Abhilash Kumar : your answer is near to solve my issue. i used the same record sort expert.but my issue is i could not see the formula field in the report expert window as i placed the formula in the group filed becuse i need the total value only to make abs() otherwise it will not be correct answer if i place the formula in detailed area. kindly check the picture i attached for your reference. once the value reach to record expert i can make asc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Refeesh,
You cannot use this formula in any of the Sorts.
Here's what you need to do:
1) Create a formula with this code:
{@Variance SR - Current Month} - {@COGS SR-Current Month}
2) Go to the Insert Summary option > Use this formula field as the 'Field to summarize'.
Choose 'Sum' as the sum function.
Under 'Summary Location', choose Group #2.
3) Go to the Group Sort Expert > Select Group #2 > Under 'For this group sort', choose 'All'.
Beside 'Based on', choose the Sum of formula field from step 2 > Choose a sort direction.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rafeesh,
Do one thing : first convert all values into positive, i.e. if any negative values then multiply it with -1 then apply ABS() (note it is not even necessary that you can apply ABS() if you have all positive values)
Try this :
If {number} < 0 then {number}*-1 else {number}
then sort it.
Thanks,
Sastry
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.