Scenario Help.

[abhaysingh]

Hi All,

i have one table in which there is SurveyTaskId,DateDue and Datesubmitted field

IF(DateSubmitted <= DateDue,   'Completed on time',

   IF(DateSubmitted > DateDue , 'Submitted Late',

       IF(ISNULL(DateSubmitted) OR LEN(DateSubmitted) = 0, 'OverDue')))  AS [TaskStatus],

right now my master calender is working on Date Submitted, so when i am selecting year, Completing on time and Submitted date are coming but overdue is not bcoz they are nulls i think.. how i can do this?

Ouput, Overdue should Also come when i m selecting any year

Regards

ABy

[tamilarasu]

Hi abhay,

Try something like,

IF(DateSubmitted <= DateDue,  'Completed on time',

  IF(DateSubmitted > DateDue , 'Submitted Late',

      IF( LEN(Trim(DateSubmitted)) = 0, 'OverDue')))  AS [TaskStatus],

Let me know,

[abhaysingh]

thanks for revert, This is some logic is working...

i want below

right now my master calender is working on Date Submitted, so when i am selecting year, Completing on time and Submitted date are coming but overdue is not bcoz they are nulls i think.. how i can do this?

Ouput= Overdue should Also come when i m selecting any year

thanks

[vincent_ardiet]

Hi Abhay,

Can you explain us your datamodel or give a screenshot of it?

You issue is maybe link to the way your data are organized.

Regards

Vincent

[tamilarasu]

You are using DateSubmitted as your master calendar field. If DateSubmitted field is blank, you can not see the Overdue when you click any year. Do you have any blank cells in master calendar? Could you post your application.? 

Ouput= Overdue should Also come when i m selecting any year

thanks

Also, you have mentioned that the overdue should display for any year. I don't understand the concept here. Please elaborate.

[abhaysingh]

Hi Vincent,

this is only one table.. no other table in data model

i Tamil Nagaraj,

yes right and concept is in Datesubmit there are null dates as well, or if i m not selecting any date than as on overdue task are showing.. but i want when i select any calendar year created from datesubmitted overdue also come..

Sorry i can't post the Sample App.

Thanks

[Mark_Little]

HI,

Maybe, add today as date submitted for the one that don't have a date, but after you apply the above logic, use a proceeding load.

Then you can use your TaskStatus flag to exclude the overdue one when you don't want to see them?

Mark

[tamilarasu]

Then you need to create a dummy date for the blank cells. But I don't think this is a good idea. You need to modify your data model and need logic.

[vincent_ardiet]

How do you use your expression?

In a straight table?

What are the dimensions you are using?

[Anonymous]

can we try sth like:

=count({<Status={'Overdue'}, Year={'=$(=year(DueDate))'>} SurveytaskID)  //Correct syntax if required