Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create a formula to only display name if criteria is met 1

Status
Not open for further replies.

mvalley

Technical User
Mar 4, 2011
80
US
I need to show the following field on a report,

{v_CRA_other_personnel.cr_other_personnel_role}="2nd Scrub" then show the name otherwise leave the field blank.
I am having trouble with this formula. What can I use?

The name field is {v_CRA_other_personnel.cr_other_personnel}
Thanks in advance
 
if {v_CRA_other_personnel.cr_other_personnel_role}="2nd Scrub" then
{v_CRA_other_personnel.cr_other_personnel_role}

-LB
 
Thank you for all you help to both my posts as well as others. I always find valuable information on this site.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top