Comparison when negative

[#1]

Hello everyone,

In my dashboard I use a flag to compare :

If(COST>INVOICED,1) as "Flag PRS > Amount Invoiced"

It works.

The problem is with negative value.

For example, I have a cost at -49€ and an invoiced at -147€.

It enter to my flag, while you would not.

Is it possible to avoid this ?

Thanks

[alexandros17 · Accepted solution]

Try this:

If(Fabs(COST)>Fabs(INVOICED),1) as "Flag PRS > Amount Invoiced"

let me know

[ashfaq_haseeb]

Hi,

look at fabs function, It will help you.

Regards

ASHFAQ

[#4]

Thanks, it works