I need to add a filter for my dashboard that will display items that have shipped [Invoice Date] before they were due [Due Date]. My expression is this:
=if ([IN Invoice Date]<[CO Due Date] and NetWorkDays([CO Due Date],[IN Invoice Date] <= 10) and (NetWorkDays([CO Due Date],[IN Invoice Date] >= 0)), NetWorkDays([CO Due Date],[IN Invoice Date]))
This expression displays numbers 1-10 in my filter, but the data does not react to the filter. For example, when 1 is chosen, many orders still show up with more than one working day between the invoice date and the due date. My logic seems sounds and I'm not sure where to proceed from here. Any help would be appreciated.
I would just add a field in the script that showed the difference between the two and you can just make selections that way. I don't really know why your method isn't working...
