Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
am using Aggr function first time.
I have done one one expression
but I need to join two aggr functions into one
Currently am working for OEE report .
Please check the below expressions
(Sum(aggr((sum({<FiscalYear={$(=max(FiscalYear))},ReworkOrder -={09,10},Type={'Machine'},//[16 Loss Group Head] ={'',''}
Date={">=$(=monthstart(max({<Flag={'Actual'}>}Date)))<=$(=max({<Flag={'Actual'}>}Date))"}>}Ptime3)),Order,Conf_Key,Date,WorkCentre,Shift)))
I want to add below expression into one
(Sum(aggr((sum({<FiscalYear={$(=max(FiscalYear))},ReworkOrder -={09,10},Type={'Machine'},[16 Loss Group Head] ={'Minor Stoppages','Reduced Speed'},
Date={">=$(=monthstart(max({<Flag={'Actual'}>}Date)))<=$(=max({<Flag={'Actual'}>}Date))"}>}Duration_DURA.ZPDWTDT)),Order,Conf_Key,Date,WorkCentre,Shift)))
Please help me..
Thanks
Surender