2 Replies Latest reply: Mar 23, 2018 6:05 AM by Sofia Vaz RSS

    Functions in set expression

    Sofia Vaz

      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,