3 Replies Latest reply: Apr 15, 2014 11:12 AM by Paul Gelardi

# Data is not showing as a percentage

I'm looking at a report setup by someone else and I can't figure out why the data for "Plan Rate" is showing as 0.03 instead of 3.0%

Below is the definition of the expression called "Plan Rate"

(sum({\$<//PlanYear={\$(=max(Year))},

Year={\$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

/

sum({\$<//PlanYear={\$(=max(Year))},

Year={\$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Com'},

CompletePeriodFlag={1}

>}

NET_SALES)-1

> 0,

sum({\$<//PlanYear={\$(=max(Year))},

Year={\$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

/

sum({\$<//PlanYear={\$(=max(Year))},

Year={\$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

NET_SALES)-1)

I looked at the Number Format Settings and it seems correct:

• ###### Re: Data is not showing as a percentage

Try

Num(Expression,'#,##0.0 %')

Antonio

• ###### Re: Data is not showing as a percentage

Looks like some problem...

is there any IF function you have used in this expression?

• ###### Re: Data is not showing as a percentage

Thanks for the quick response. I believe I was looking at a disabled expression. So the problem is somewhere else.

Thanks anyway.