Change the Number format for one value from the Expression

[#1]

Hi,

My input table structures looks like something that is mentioned below:

Week	Sales
Week1	10
Week2	20
Week3	30
Week4	40

I want to add a text box in the dashboard, that would only show the sum(sales) for Week4. And also the format for the expression should be in '%' value.

I tried applying the following expression in the text box, however it did not work !

Formula: =sum({$<Week={'Week4', '#,##0%'}>}[Sales])

Any thoughts on this ?

~Shalaka

[jaimeaguilar]

Hi,

try like this:

num(sum({$<Week={'Week4'}>} [Sales]), '#,##0%')

The % format has to be set by a function (num in this case),

regards

[MarcoWedel]

Hi,

another solution:

=Num(Sum(If(Week='Week4', Sales)), '#,##0%')

hope this helps

regards

Marco