How to calculate Webi Overdue Count (XI 2)

[former_member411068]

Simple webi report

I need to Count if is overdue

Manager	Assign Count	Assign Completed	incomplete	Complete Status	Overdue Count
Jay Kumar	500	450	50		?
Bill Jones	400	375	25		?
Tina Cohen	300	295	5		?
Tiger wood	200	195	5		?
Jelly tiza	10	10	o	Completed

I need a overdue Count , I have a column in Complete status as set as Alerter if completed show green if over due in red if incomplete in red  but how to count red incomplete from Complete status column for overdue I need  the formula  Thank You

Regards,

[Former Member]

Assign Count - Assign Completed = Overdue Count.

but column "incomplete" itself giving the count you need.

or explain, what you want to see in Overdue Count!

[former_member411068]

Praveen

Its donne very simple Assign Count - Assign Completed

but my Question is how we count OverDue

when we have Assign - Assign Complted = Incomplete

but Incomplete has some overdue base upon date's

How to calculate Overdue ? I have a an other Column(Object) (Assign due dates  ) I need some formula

where I can range the date and convert in to Counts Overdue

Currently I am using this Example (=FormatDate([Assignment Due Date];"yyyy-MM-dd")>FormatDate(CurrentDate();"yyyy-MM-dd")

Above Formula I have used for Alerts when OverDue show red .

I want to have simple Formula which make sense I think above chart has lot of detail .

Thank You

[former_member411068]

Praveen /Rakesh

Overdue count has some incomplete and some count goes by date's.

like few counts date 06/09/2013 they consider Incomplete the date has cross now they over due but some count will be 6/15/2013 they consider Incomplete but not over due so that's why incomplete count has mix count they only way to identify we need to use date current function Please advise Thank You

[Former Member]

Hi Siddiqui,

Can you try this-

1) Create one measure object in Webi report with this formula-

Overdue Count=If (FormatDate([Assignment Due Date];"yyyy-MM-dd")>FormatDate(CurrentDate();"yyyy-MM-dd")) Then 1 Else 0

2) Use this Overdue Count variable to map Overdue Count column in above chart. This will give you count of all the assignment which is over due date for each manager.

Let me know if it helps you.

Regards,

Anuj

[former_member411068]

Hello Anuj,

Thanks for your response

Overdue Column  has
some incomplete and overdue They are mix

What I did    Incomplete
- Count Completed = Overdue but that’s wrong

When I used your formula it did not work I was getting Error I want to give an other way to resolve Incomplete -complete = overdue then overdue as present date but still same problem .

[former_member411068]

Simple webi report

I need to Count if is overdue

Manager	Assign Count	Assign Completed	incomplete	Complete Status	Duedate	Overdue
Jay Kumar	500	450	35		05/30/2013	15
Bill Jones	400	375	31		6/01/2013	4
Tina Cohen	300	295	2		06/06/2013	3
Tiger wood	200	195	2		06/07/2013	3
Jelly tiza	10	10	0	Completed	6/10/2013	0

I need a overdue Count numbers , I have (Complete status)  Column its only show dimention object like complete as Alert now I want to count in OverDue in next Column as Above Thank  YOU

Regards,

Imran

[former_member189638]

Can you please tell which columns are coming from the dataprovider and which columns are being calculated at the WebI level??

From the above example, what I understand is Overdue = Assign Count - Assign Complete - Incomplete..Not sure where are you facing the issue while calculating the Overdue.

[Former Member]

you can achieve this by simple formula/ create a new variable in your report.

=[Assign Completed] - [Incomplete]

[former_member189638]

In the Alerter you can use the Incomplete Column and check if the value is 0 then highlight the Overdue Column as Green.. If the value is not equal to 0 than highlight it as Red

[former_member411068]

Rakesh ,

Thanks for your response , I need to count Overdue in numbers  Like this manager Tigerwodd  has 5 overdue in above Chart .

As Alert in coulmn I can show them but I need a next column with numbers like how many Overdue.for each manager Overdue . I need a formula to show this manager has that manay Overdue . Thank YOU

[former_member189638]

If I have not mistaken the column Incomplete which is Assign Count - Assign Completed itself represents the Overdue..right??