Stacked Bar format Issue

[alec1982]

Hi Guys,

I have a stacked bar chart with two expression and I have the format of the nrs in the chart like Num(Sum(Sales),'$#.##0')  on both of the expression.

Now the total nr that is showing on on the chart for both expression is not getting formatted. if I move the mouse over any of the stacked bar I see the foramts in the pop up text.

Any idea on how can I format the nr that is showing on data point for both of the expression?

Thxs,

Badr

[MayilVahanan]

Hi

In number tab, check the expression default is assigned for both the expression

Hope it helps

[alec1982]

Hi Guys, thxs for the reply , I am limited on the number tab option. I cannot use it on this chart because the expression has toggle on it

it is like:   if(Var1 ='1', Num(Sum(Sales)/ Sum(Total Sales),'#.##0%),Num(Sum(Sales),'$#.##0))

So basically I need to put the format in the expression. but it is not working for stacked bar chart

and It is Expression default on both of them

[MayilVahanan]

HI

Can you post a sample file?

   if(Var1 ='1', Num(Sum(Sales)/ Sum(Total Sales),'#.##0%' ),Num(Sum(Sales),'$#.##0' ))

And one more doubt, in that expression you didn't close single quotes?

[alec1982]

I cannot post a sample, it is a huge qvw. also sorry I didnt close the single quote on the discussion only.