Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Im using this:
Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time])
to get time duration. Now I would like use result time to get Avarage time for [TO shipment] in my selected data. I tried:
avg (aggr (Max(${<[TO shipment]>}[Over Date Time])-Min(${<[TO shipment]>}[Conf.tDate&Time]),))
but this one dont work. Result in my tab is " - ".
Please, can anybody help me? Sorry, for my english. Thank you for your help.
May be this
Avg(Aggr(Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time]), [TO shipment]))
May be this
Avg(Aggr(Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time]), [TO shipment]))
Thank you Sunny, it work.