I have a date 1 and date 2.
Used datediff ('day', date 1, date 2 ) > 0. If difference > 0 then inefficient else efficient. simple logic and count is calculated.
But if i have null inside date it is showing 'efficient'. I need that to be grouped in 'inefficient' and count should also be correct.
Hi Siva. You can try IFNULL(Datediff('day',day1,day2)>0,inefficient). See if that does the trick. It would be helpful if you post a workbook so I can make sure that the data structure will work with the formula. It may need to be modified as necessary.