Absolute value in calculated item

[krysi]

Hello everybody,

I try to find a way to calculate an absolute value in the calculated item.
For example I have two values x and y. It should calculate last(x) - last(y) but sometimes x is lower than y. What I need is only the difference between this two values, without a negative or positive sign in front of it. Could anyone help me with this topic?

Thank you in advance.

[Noobz]

Did you get this to work? I'm running into the exact same issue.

[Semiadmin]

(last(x) > last(y)) * (last(x) - last(y)) + (last(x) < last(y)) * (last(y) - last(x))

[Noobz]

(last(x) > last(y)) * (last(x) - last(y)) + (last(x) < last(y)) * (last(y) - last(x))

Sure, but why does abs not work as a calculated item, it works fine as a trigger function.
You may as well just sq then sqrt the value

[Semiadmin]

Depends on version.
In 5.4 abs(last(//x) - last(//y)) works well.

[Noobz]

Hmm, maybe I'm doing it wrong but I couldn't get that to work on 5.4.9 - however, I had no problem making it work as a trigger.