Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a need to get the QTY un-received for the earliest order with a un-received QTY greater than 0.
In another column on the straight table I currently get the next Order Date for this by using:
=Min({$<[PO Unreceived QTY]={'>0'}>}[PO ETA])
I have tried to use the below to get the [PO Unreceived QTY] for the same order, but this only works when i make the selection for particular items, if not making a selection the returned value is based off all items. I have tried to include and exclude certain Tables and Fields, but this does not seem to work.
=Sum({$<[PO ETA]={'$(=Min({$<[PO Unreceived QTY]={'>0'}>} [PO ETA]))'}>}[PO Unreceived QTY])
Is there a way to have the Min date value return the line value rather than the value based on the entire data set?
May be try this
FirstSortedValue({$<[PO Unreceived QTY] = {'>0'}>} [PO Unreceived QTY], [PO ETA])
May be try this
FirstSortedValue({$<[PO Unreceived QTY] = {'>0'}>} [PO Unreceived QTY], [PO ETA])
Thank you Sunny, this works for what i require.