How do I add null values to my count

[#1]

I am using the formula below to find work orders that are late.  I would like to add to my count the work orders that have a null completed date and the WO Required Date.AgeInDays >=1.  Any ideas would be greatly appreciated.  Thanks in advance for your help on this item.

count (if([WO Complete Date.CalendarDate] > [WO Required Date.CalendarDate],1))

[Anonymous]

Try this

count (if([WO Complete Date.CalendarDate] =''))

or

count(if(isnull(([WO Complete Date.CalendarDate])

If this doesn't work let me know

[Anonymous · Accepted solution]

Maybe something like this ?

count (

  if([WO Complete Date.CalendarDate] > [WO Required Date.CalendarDate] ,

       1)

)

+ count( if (  [WO Required Date.AgeInDays] >=1 ,

                      if ( isnull([WO Complete Date.CalendarDate] ) ,

                                1 )

  )

[#4]

Hello Jebamalai,

Thanks for the response. Unfortunately, neither of the formulas below worked.

Regards,

Shedrick

[martynlloyd]

Check out The NullAsValue statement.

[Anonymous]

What kind of 'not work' ?

[#7]

Bill,

It looks like it is working now. I just added one last ) on the end of the expression and now it is ok. I am going to do some more testing to ensure it is working properly. Thanks so much for your help.

Regards,

Shedrick