Jump to content

Label Calculation


This topic is 5771 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I am trying to modify a label calculation, and it is telling me I am missing the operator. It must be the end of the day (or just cause I am a novice) but I don't see where I am missing one. Here is the calculation:

Case(not IsEmpty(Partner Name) ; Partner Name & " " & "and" & " " & First Name & " " & Last Name); IsEmpty ( Last Name ); Company; First Name & " " & Last Name

Basically, I am trying to have it search for a partner name; if there is a partner name put in "partner name and First Name Last Name. If there is no Last name, put in the Company; otherwise just do First Name Last Name. TIA

Link to comment
Share on other sites

Case (

not IsEmpty(Partner Name);

Partner Name & " and " & First Name & " " & Last Name ;

IsEmpty ( Last Name ); Company;

First Name & " " & Last Name

)

In your code, you had the closing ')' in the wrong place

Case(not IsEmpty(Partner Name) ; Partner Name & " " & "and" & " " & First Name & " " & Last Name[color:red]); IsEmpty ( Last Name ); Company; First Name & " " & Last Name [color:green])

Link to comment
Share on other sites

This topic is 5771 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.