I am creating a Business Objects report and in one of the field I have this
=If([MgrApproved]="N" And [ApprovalRequired] = "Y";"Pending";"Approved")
This gives me either Penidng or approved.
What I want is a third option that if if the first optin is N and the second option is N that I get the answer of "Declined"
How would the If then statement go in Business Objects Report