Set Analysis - count orders with two different load dates
I am trying to build a KPI to show the number of sales orders that have more than one Load Date, which we should never have multiple load dates per order.
Currently I have a report using the logic below, and it works, because I have SALES_ID as a dimension on the report. However, if I want to count the amount of order with multiple load dates, it is not working for the KPI object.
I believe your solution works. It seems simple but I could not get it right. I was using the logic below with the IF function in the wrong place, so it was still summing all distinct Load Dates, regardless of the Sales_ID.