I’m a total novice to Business Objects and have only been working with this for a couple of months, but i am struggling with an IF statement for a report that i need to write…
What i need the statement to do is
IF [plan update] is less than or equal to 199 then display “Yes”
IF [plan update] is greater than or equal to 200 then display “No”
Else display “No Plan”
I can get the function to work, but instead of displaying what i want it to, it displays a “0” for <=199 and a blank cell for >=200
The statement I’ve used is:
=If([No.of days since plan eff/plan auth]<=199) Then “Y”
=If([No.of days since plan eff/plan auth]>=200) Then “N”
Your syntax does not include everything required for a nested if statement and is defaulting to a 1/0 output, then not recognizing anything beyond the first line. You either need to simplify this into a straightforward if/elseif/else statement (much less confusing early in the BO learning curve):
=If [No.of days since plan eff/plan auth]<=199 Then “Y” ElseIf [No.of days since plan eff/plan auth]>=200 Then “N” Else “Plan not recorded”
Or complete the syntax for a nested if:
=If([No.of days since plan eff/plan auth]<=199;“Y”;If([No.of days since plan eff/plan auth]>=200;“N”;“Plan not recorded”))
