Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
can you please help me to convert this into set analysis
actual one
=SUM(AGGR(IF([Gate DRD]=1
AND [Gate Status]='Open' AND NOT(ISNULL([PLM Project ID]))
AND [Gate Actual Start Date]<>'-'
AND [Gate Actual End Date]<>'-'
, Networkdays([PLM Project Actual Start Date],[Gate Actual End Date])),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date],[PLM Project ID]))
i have converted like below but not working because of network days
=Aggr(Sum({<[Gate DRD]={1}
, [Gate Status]={'Open'},PLM_NullFlag={1}
, [Gate Actual Start Date]-={'-'}
,[Gate Actual End Date]-={'-'}
,Network_PLM_GATE>}[PLM Project ID]),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date])
May be this
Sum({<[Gate DRD] = {1}, [Gate Status] = {'Open'}, PLM_NullFlag = {1}, [Gate Actual Start Date] -= {'-'}, [Gate Actual End Date] -= {'-'}, Network_PLM_GATE>} Networkdays([PLM Project Actual Start Date],[Gate Actual End Date]))
Not working above one
can you convert this, consider aggr one as well
SUM(AGGR(IF([Gate DRD]=1
AND [Gate Status]='Open' AND NOT(ISNULL([PLM Project ID]))
AND [Gate Actual Start Date]<>'-'
AND [Gate Actual End Date]<>'-'
, Networkdays([PLM Project Actual Start Date],[Gate Actual End Date])),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date],[PLM Project ID]))
consider aggr one also? What does that mean?