Skip to Content
Former Member
Jul 19, 2010 at 05:02 PM

percentage not correct


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


({@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?