I am building a Set Analysis based on two dates, Load Date and Inventory Date. The condition is that, if a Load Date for another falls on the same date of an inventory date, it should raise a flag, cause we avoid loading on inventory dates.
I tried building a set analysis like below, however, it is not working. The set analysis I tried is below:
This works. I knew it was a simple solution using IF, but I couldn't figure out the right place to use. Very good to know that it would not work with Set Analysis. So, Set Analysis never estimate conditions at row level?