Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to filter a set expression for the maximum InventoryFrozenInventoryDate value... In order to achieve that, I've written this expression:
Sum({<InventoryFrozenInventoryDate={"$=max(InventoryFrozenInventoryDate)"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)
However, it's not working… does anyone knows what I might be doing wrong?
Thank you,
Sofia
Sum({<InventoryFrozenInventoryDate={"$(=max(InventoryFrozenInventoryDate))"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)
Sum({<InventoryFrozenInventoryDate={"$(=max(InventoryFrozenInventoryDate))"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)
Thank you Omar! It works! What a silly mistake I did...!