Hi Guys,
I am trying to write a variable which is an if statement with in Business Objects but it isn't playing ball.
This is what I think I wanna type:
=If<Outcome Date> = "" Then(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> , CurrentDate())Else(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> ,<Outcome date>))) End If
Can anyone see where I am going wrong here??
Cheers
JB
I am trying to write a variable which is an if statement with in Business Objects but it isn't playing ball.
This is what I think I wanna type:
=If<Outcome Date> = "" Then(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> , CurrentDate())Else(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> ,<Outcome date>))) End If
Can anyone see where I am going wrong here??
Cheers
JB