null count

[soniasweety]

Hi all,

I  have KPi object

if(today()>duedate,1,0) as DueDateFlag,               -----  this expression in script used.

KPI expression:

ount({<DueDateFlag={1},iD-={'3','4'}>}Number)

here logic is greater than due date  from today values should count   but I have 8 null values it is not counting  so how to include that?

[soniasweety]

end date is timestamp

12/29/2017 2:10:30AM

[sunny_talwar]

end date? what do we need end date for?

what about the due date? is that a timestamp also?

[soniasweety]

sorry sunny due date only  its timestamp only

[sunny_talwar · Accepted solution]

Then may be do this

If(Now() > Alt(duedate, Today()-1), 1, 0) as DueDateFlag,

or your DB check should be by truncating the duedate to just date based on your requirement

[sasiparupudi1]

DueDate='2018-04-27 17:31:27.733'

May be try

=If(IsNull(DueDate) OR(Today()>Date(Floor(Timestamp#(DueDate,'YYYY-MM-DD hh:mm:ss.fff')))),1,0)

[soniasweety]

this gave correct result

If(Now() >due_date, 1, 0) as DueDateFlag,