Object Report - Field Evaluation

[NK2080]

Hi All,
In Object Report, I need to show mother's cell phone if her home phone is not available.

The following code is in the report
^([Students.StudentCoreFields.mother_home_phone];if.blank.then=[Students.U_StudentsUserFields.mother_cell_phone_on])

On report run, the following is the output regardless of mother's home phone availability.

[Students.U_StudentsUserFields.mother_cell_phone_on]

How can I fix the issue?

Thank you for your help

[B_Brock · Accepted solution]

Try this...

^([Students.StudentCoreFields]mother_home_phone;if.blank.then=^([Students.U_StudentsUserFields]mother_cell_phone_on))

[B_Brock · Accepted solution]

Try this...

^([Students.StudentCoreFields]mother_home_phone;if.blank.then=^([Students.U_StudentsUserFields]mother_cell_phone_on))

[NK2080]

Thank you for the code.  It worked.

I need to put word "ext" before actual extion number only if there is extention avalable. 

Using the same logic, I'm using the code below that is not working.  Any suggestion.

^([U_StudentsUserFields]MOTHER_WORKEXT_ON;if.not.blank.then=ext)

[B_Brock · Accepted solution]

Hi.

Try this:

^([Students.U_StudentsUserFields]MOTHER_WORKEXT_ON;if.not.blank.then=ext)

[NK2080]

Than you!! It worked.