This content has been marked as final.
Show 3 replies

1. Re: Count
Andrew Watson Aug 19, 2016 5:24 AM (in response to Siva raja)SUM(IF ATTR(DATEDIFF('day',[Date1],[Date2])) >1 THEN 1 END) / SUM([Number of Records])

2. Re: Count
Swarnalatha Mannar Mannan Aug 19, 2016 5:27 AM (in response to Siva raja)Hi Siva raja
Efficient/Inefficient Calulation
IF (DATEDIFF('day',[Order Date],[Ship Date])) <=1
THEN
'Efficient'
ELSE
'Inefficient'
END
Count of InEfficient
IF [Efficient/Inefficient] = 'Inefficient'
THEN
1
ELSE
0
END
Inefficiency Irrespective of category
WINDOW_SUM(SUM([Count of inefficient]))
Total InEfficiency
SUM({ FIXED [Category]:SUM([Count of inefficient])}) / WINDOW_SUM(SUM([Count of inefficient]))
Kindly let me know if this what your expectation.
Regards
Swarnalatha Mannar Mannan
