Sort by greatest deviation

[Theo_Westseit]

Hello Guys,

I am currently stuck developing an application.
Ive created a table with three columns:

Is	Plan	Deviation
100	70	+30
5	10	-5
30	70	-40
70	50	+20

The Code at Column Deviation looks like this:

(Sum({<Year={"$(=max(Year))"}>}Is)
-
Sum({<Year={"$(=max(Year))"}, Version={"000"}>}Plan)

I would like to sort the Values in Column 3 by greatest Deviation (wherever its + or -)

So the Table should look like this:

Is	Plan	Deviation
30	70	-40
100	70	30
70	50	20
5	10	-5

Do you have any ideas? Thanks in advance!

[stevejoyce]

I meant insert fabs in the Sort by expression, not the actual expression.  But if it's an expression you can't sort by a specific expression.  This should work.  Leave Number format to Auto (not number) and sort numerically Descending

dual(num((Sum({<Year={"$(=max(Year))"}>}Is)
-
Sum({<Year={"$(=max(Year))"}, Version={"000"}>}Plan),'#,##0 $;-#,##0 $'),
fabs((Sum({<Year={"$(=max(Year))"}>}Is)
-
Sum({<Year={"$(=max(Year))"}, Version={"000"}>}Plan)
))

[Theo_Westseit]

Thanks guys! It works perfect now!