170
Hi,
I have a question on using the ABS function in Management Reporter.2012. I am using the following formula:
IF C=0 THEN 0 ELSE D/ABS(C)
Management Reporter doesn't accept this formula, but if remove the ABS function it has nor problem saving my column format.
Anyone has any idea what may be wrong with the formula?
Please help.
Thanks
Amir
*This post is locked for comments
I'm having a similar issue when an ABS formula previously used in FRX. I've tried variations of (IF C<0 THEN -C ELSE C); but can't seen to get the correct results.
Here's my current formula: IF ABS(E)>2500 THEN C ELSE 0
Thanks in advance for any and all suggestions.
La Tonya
If you want the entire value to use absolute value, you can also use a custom format override of "0;0". This will suppress the minus sign in front of the number.
Thanks for the reply Clay. But this is what we did to fix this issue too. But it is really weird that MR doesn't provide a simple function like this.
There are so many other things that are missing from MR that were present in FRx. Our customers are having very difficult time using MR because of those missing things.
Not elegant, but I fixed by replacing ABS(C) with (IF C<0 THEN -C ELSE C).
Hi,
Has anybody else come across through this issue, or has any idea why ABS function gives an error?
Thanks
Amir
Hello,
Can anyone please help with this issue. I have a client waiting, they need to run their month-end and can't because of this issue.
Thanks
Amir
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (