Variable in webi

building reports webintelligence
1

Hi There,

My users previous requirement was:

=If (([WO Status] InList("INPRG" ; "WRKDN" ; "BILLED" ; "APPLIED" ; "APPLYFOR" ; "CLOSE")) And ([Actstart]<=[Respondby]) And [Worktype]= "RW") Then("Completed Status in SLA")

He wants me to add IsNull[Respondby] to the above formula to get (“Completed Status in SLA”) output. How do I get it. Please see attached sample data

[Moderator Edit: Added code formatting - Andreas]
RW.PNG

chazp (BOB member since 2015-03-04)

2

If I gather your request clearly…

=If (([WO Status] InList("INPRG" ; "WRKDN" ; "BILLED" ; "APPLIED" ; "APPLYFOR" ; "CLOSE")) And ([Actstart]<=[Respondby] Or IsNull([Respondby]) And [Worktype]= "RW") Then("Completed Status in SLA")

BO Bozo (BOB member since 2009-09-22)

3

Thanks a lot. This helped

chazp (BOB member since 2015-03-04)