21 Replies Latest reply: Mar 13, 2018 12:13 PM by Sunny Talwar RSS

    Best before by...

    kjh hjjh

      Hi

       

      I need to separate product based on their expiration date. I have two fields called:

      - "Max Time":  Products dimension, has the number of days that a product is still in good quality

      - "Item Time":  Has the number of days since the product has been manufactured, from today.

       

      I want to create an expression with set expression, to count all the products that are out-dated. I was trying with something like this, but is not working:

       

      =Sum({<ItemTime={">$(=MaxTime)"}>}#Box)

       

      How should I do this?

       

      Thanks!!