Simple webi report
I need to Count if is overdue by dates Incomplete means you have not completed but overdue when you have due date to completed but you have past due the date they consider overdue I hope I am making sense on this chart
Managers
Assign Count
Assign Completed
incomplete
Complete
Status
Overdue Count
Overdue Percent
Jay K
500
450
50
-1
Bill Jones
400
375
25
8
Tina Cohen
300
295
5
6
Tiger wood
200
195
5
8
Jelly tiza
10
10
0
0
Above chart explain the story I have a Object which Count Due dates in that Object I have only Due dates (Assignment due date)
I have created a variable which count Assignment due dates without ranging a dates just simple = Count Assignment due date
above chart look simple but confusing anyway what I did incomplete - Assign Completed= Overdue
I do get the result in above Overdue Column but they are completely wrong someone suggest me to use
Count=If (FormatDate([Assignment Due Date];"yyyy-MM-dd")>FormatDate(CurrentDate();"yyyy-MM-dd")) Then 1 Else 0
That formula stuck at year i do bold the Error Count=If (FormatDate([Assignment Due Date];"yyyy-MM-dd")>
I hope someone knows how to calculate this object by current dates
Please response ASAP.
Thank You
Best Regards,
Imran