Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do i compare two dates with additional condition in set analysis, i tried the following but seems to be i am missing something.
Basically what i am trying to do is taking count of status, if completion date is greater than due date.
=count( {<[Completion Date] = {">$([Due Date])"},Status={'Closed'} > } Status)
Many thanks in advance
May be this?
=count( {<[Completion Date] = {"=[Completion Date]>[Due Date]"},Status={'Closed'} > } Status)
i tried this , count is zero
Can you please create one more field in script as
Load *, If([Completion Date]>[Due Date], 1,0) as Flag;
and the expression like
=count( {<Flag = {'1'},Status={'Closed'} > } Status)
Many thanks,
it worked like a charm.
