Skip to Content
0
Jun 12, 2013 at 03:51 PM

How to calculate Count by present date (XI 2)

31 Views

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