Is it possible to change the format of an expression if a value is different

[#1]

I have a pivot table shown below:

What I need to do is have the Gross Margin @ FGS shown as a percent instead of like the other numbers.  Would it be possible to do this????

Here's how I have the expression written:

if ( Measure<>'Gross Margin @ FGS',

sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(Value)), vGrossMargin)

So I set the vGrossMargin number format at the document properties level to show in percent but it has taken the form of the column which is fixed with no decimal places.

Is there a way to get only the last item as a percent???? I want it to show 53.4%

[mambi]

i think you can use this :

if ( Measure<>'Gross Margin @ FGS',

sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(Value)),Num( (vGrossMargin),'#,##0%') )

[#3]

I tried that & it doesn't seem to work.

[#4]

Scratch previous reply.  I had to go in and change the number format for the expression to expression default.

[mambi]

does it work  ?

[#6]

It does work now but I need it to say 53.4% and it is showing 5336.90%

[mambi · Accepted solution]

Num( (vGrossMargin)/100,'#,##0%')

[#8]

I did Num( (vGrossMargin)/100,0.0%') and that did it.

Thanks!!!

[mambi]

don't forget to mark your post as solved