Pull data based on condition

[Chuku]

Hi,

I need to display Operator Names in my report. From the front end, this field can be created based on Role or User Name.
When created by UserName, entries are created in Worklog.AssignedID and when created by role this field is null.
For Role based, entries are created in LoanOper.OperID. This field is notnull field. I need to write a formula to pull both userName and role based values. a Simple if else doesnt work on this. How to proceed. Could anybody help

 

[Charliy]

if isnull({worklog.AssignedID})
then {LoanOper.OperID)
else {worklog.AssignedID}