Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to fetch results with using Aggr in Value list.

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.  

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Anil ,

Thanks for reply .

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

View solution in original post

5 Replies
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)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful