Unable to fetch results with using Aggr in Value list.

[Anonymous]

Hi ,

I have different expressions stored in variables in one valuelist  expression  I'm fetching data with aggr function but it is giving error  if I use it in value list().

num(round($(Variable21)),'##,##,###'),
//(sum(aggr($(vOEE)*$(vWeight),Cell,CellType,PlantCode,PlantName)))
Num($(vOEE)*$(vWeight), '#0 %')

Commented part is fetching wrong results .

There are two dimensions :

1. Value list fetching.

2. =CalendarMonth&'-'&Right(CalendarYear,2)

It was according to report needs, that I had to use value list .

Any inputs are appreciated. Thanks in advance.  

[Anil_Babu_Samineni]

Would you elaborate variable as well vOEE, vWeight ??

May be try this?

(sum(aggr(Num($(vOEE)*$(vWeight),'#0%'),Cell,CellType,PlantCode,PlantName)))

[Anonymous]

Hi  ,

Nope its not working ,

These are basically expressions :

vWeight = ((sum([Cycle Time]))
/sum(TOTAL<CellType>[Cycle Time])
)*100

vOEE=

(($(vAvailability))
*
($(vPerformance))
*
($(vQuality))
)

  its variable which contents other variables so it basically four level variables

[Anil_Babu_Samineni]

Would you able to provide sample, Please?

[Anonymous · Accepted solution]

Hi Anil ,

Thanks for reply .

It has been solved by using pick match instead of Valuelist.

[Anil_Babu_Samineni]

You mark as Assumes Answer, Try to flag correct answer of your response