Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
))
Thanks guys! It works perfect now!