see the attached -
In your formula there is a logic issue - a date cannot be 2018 01 04 AND 2018 01 01 so you won't get the difference between the 2
this will work
and it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Question_v10.2.twbx 56.2 KB
Thank you for advice!
I tried this way before, but it can't be used by filter
Can you apply filter on 'Product' to pick Top 1 Product by using 'difference formula'?
Due to characteristic of table calculation, it doesn't work..
I want to display Top 2 Product in Top 1 region based on M/S difference between 1/1-1/4.