Hi
I have been using a lot of variable derived out of expressions for charts. no problem, they are working fine. Now i am enhancing some charts which require filtered selection for calculation - hence using set analysis.
eg: e_Utilization (variable) - reference =
$(e_Production_Uptime_Minutes) / $(e_Production_Available_Minutes)
e_Production_Uptime_Mins = (sum([Uptime Minutes])-sum({<[Event Utilization Subcategory] = {'Planned Downtime'}>} [Uptime Minutes]))
e_Production_Available_Mins = (sum([Available Minutes]) - sum({<[Event Utilization Subcategory] = {'Planned Downtime'}>} [Available Minutes]))
Now i use them in my set analysis
SUM({1<
[Line Name] = {'LINE 02'},
CalendarDate = {'$(v_RptDate)'}
>}
$(e_Utilization)
)
Returns nothing.
Anything i am missing / doing wrong.
Appreciate any suggestions/help/comments and your time.
Thanks
