conditional display of rows in a straight table

[#1]

Ihave npot been on training yet so I m sure this is simple

i need to generate a table that only displays active employees with an absence that is either has no end date or an end date after today

i have two calculated dimensions in this table

=IF(IsNull(\Employee.EndDate)=-1 and Len(EmployeeNo)=6 and IsNull(\UNAVAILABLE.UNAVAIL_ID)=0,ContactClockNo,'Inactive')

=IF(IsNull(\Employee.EndDate)=-1 and Len(EmployeeNo)=6 and IsNull(\UNAVAILABLE.UNAVAIL_ID)=0,\UNAVAILABLE.UNAVAIL_ID,'Inactive')

if itry to add IsNull(\UNAVAILABLE.EndDate)=-1 then the Inactive rows are diaplayed

any help would be appreciated

[#2 · Accepted solution]

Hi,

because sometimes the proof of nullvalues can be misleading, I am using instead any null()-function the LEN()-function. If your field is empty or null, LEN() will return 0, else the length of the content:

=IF( LEN(\Employee.EndDate)=0 and Len(EmployeeNo)=6 and LEN(\UNAVAILABLE.UNAVAIL_ID)>0

HtH

Roland

[#3]

Roland thanks that seems to be working but i have one other question

the ENDDATE field is formatted dd/mm/yy hh:mm:ss

and i have no idea how i could construct th expression to include any endate after TODAY

apprecaite any help

[#4]

sorted this thanks