ABS value

(0) Share

Report

Posted on by LTChambers

POSTED BY LTCHAMBERS

ON 10 DEC 2013 7:56 AM

I'm having an issue with an ABS value formula migrating from FRX to Management Reporter. I've tried variations of the (IF C<0 THEN -C ELSE C) formula noted in a previous post ; but can't seen to get the correct results.

Here's my current formula: IF ABS(E)>2500 THEN C ELSE 0. The formula is being used in a variance report that compares actual to budget and should populate if the variance is greater or less than 2500.

Thanks in advance for any and all suggestions.

i posted this before; but not sure if I did it correctly

La Tonya

*This post is locked for comments