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,

       

      Sofia