Help

Your community experience is moving to Customer Central, our new portal, this summer, with a more intuitive experience. Learn More.

Object Report - Field Evaluation

NK2080
Practitioner

Object Report - Field Evaluation

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

0 Replies