Functions in set expression

[Anonymous]

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

[OmarBenSalem · Accepted solution]

Sum({<InventoryFrozenInventoryDate={"$(=max(InventoryFrozenInventoryDate))"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)

[Anonymous]

Thank you Omar! It works! What a silly mistake I did...!