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:
How should I do this?
Solved! Go to Solution.
I'm not the OP but I'm confused about the comparison between the Product and ItemTime. How should I interpret that? Just trying to gain more strength on complex set-analysis issues.
You do have a dimension called Product, right ... might sound dumb... but a lot of the times people just copy paste the expression without replacing the fields... you have to use the product field for Product in the expression I provided....