If statement help

[Stewman]

Hello,

Need some assistance with an if statement. It is returing values of true or false instead of other values I want.

Statement:
If {APPROVAL_LOG_HISTORY.APPLVL} = 2 and {APPROVAL_LOG_HISTORY.APPDESC} = 'approve' then {APPROVAL_LOG_HISTORY.ROLENM} = 'Final Approval'
else {APPROVAL_LOG_HISTORY.ROLENM} ={APPROVAL_LOG_HISTORY.ROLENM}

What I want is if approval level = 2 and description = approve then display in the Role column Final Approval. If it doesn't meet these requirements then display the Role value that it should be.

Any help appreciated!!

 

[lbass]

If {APPROVAL_LOG_HISTORY.APPLVL} = 2 and
{APPROVAL_LOG_HISTORY.APPDESC} = 'approve' then
'Final Approval' else
{APPROVAL_LOG_HISTORY.ROLENM}

-LB

 

[Stewman]

Thanks for your help. I'm such a bonehead. Worked perfectly.