Announcements
cancel
Showing results for
Did you mean:
Not applicable

## 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:

1 Solution

Accepted Solutions
Not applicable
Author

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

Thanks anyway.

3 Replies
Master III

Try

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

Antonio

MVP

Looks like some problem...

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

Not applicable
Author

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

Thanks anyway.

Community Browser