on 07-19-2010 6:02 PM
i have a report which shows percentage.
my formula to calc the percent is
if{@season total }= 0 then 0
else if {@TOTAL ORDER COLOR}=0 then 0
else
({@TOTAL ORDER COLOR}/{@season total }*100)
the values i am using are -5586 / -71837 should be 7.78% it is displaying 100%
i know there are issues with percentages in 2008. cant use a sp2 to correct this as it doesnt play well with our lawson app.
anyone know how to fix this?
See this post for more info on what to do with percentages:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
that didnt work still shows as 100%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This could be a formatting issue
I have just done a test on a formula which returns 98.75, but in Format -> Number ->customise
If rounding is set to 10 then it returns 100.00
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sharon,
Lawson should be on SP2. Have you checked with them to see if you can apply SP2? They may have an update to their application also.
I'm on SP3 now. Have you tried SP1 as a test?
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is it only when both values are negative?
Its not a fix but this work around could do the trick
local numbervar val;
local numbervar denom;
If {@season total } < 0 then denom:= {@season total }*-1 else denom:= {@season total };
If {@TOTAL ORDER COLOR}< 0 then val:= {@TOTAL ORDER COLOR}*-1 else val:= {@TOTAL ORDER COLOR};
if denom = 0 then 0
//else if {@TOTAL ORDER COLOR}=0 then 0 no need for this test
else
val % denom
Hi Sharon, I have CRXI, so I assume 2008 will function in a similar way
Another thing I do, is create an error in the formula
Your Formula
if{@season total }= 0 then 0
else if {@TOTAL ORDER COLOR}=0 then 0
else
({@TOTAL ORDER COLOR}/{@season total }*100)
mine (with an error)
({@TOTAL ORDER COLOR}/{@season total }*100) / 0
when you run it, CR should stop, and show you the values that caused the error.
you will then know for sure, what is being divided by what. Sometimes this information can be
helpfull
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.