Problem with KPI expression

[aheavy95]

Hi I used this calculation for formatting large numbers:

this expression as a KPI measure works:

pick(vKPI_TOTAL_NET,$(vScaleNumber2(Sum({$<Year={2007}>}TotalDue))),$(vScaleNumber2(Sum({$<Year={2007}>}SubTotal_SO)))) 

But for some reason it doesn't work when I add the months , I get an error in the expression: 

pick(vKPI_TOTAL_NET,$(vScaleNumber2(Sum({$<Year={2007},[Month Num]={7,8,9,10,11,12}>}TotalDue))),$(vScaleNumber2(Sum({$<Year={2007}>}SubTotal_SO))))

any idea why?

Thanks a lot

[lukas_]

Hello,

You can't use a comma in the set analysis of the parameter. You have to find a way around it, when possible

[vinieme12]

unfortunately coma's don't work with nested variables

the work around is to eliminate coma's completely from set analysis

Try below

Sum({$<Year={2007}>*<[Month Num]={"(7|8|9|10|11|12)"}>}TotalDue)

[aheavy95]

perfect that worked.

Now, Im trying to ignore a "year" filter. do you know how can I achieve this with that kpi expression ?

pick(vKPI_TOTAL_NET,$(vScaleNumber2(Sum({$<Year={2008}>}TotalDue))),$(vScaleNumber2(Sum({1}{$<Year={2008}>}SubTotal_SO))))