AnsweredAssumed Answered

How to do a calculation if there is an empty field

Question asked by PatriciaAngelini on Sep 5, 2014
Latest reply on Sep 5, 2014 by PatriciaAngelini

Title

How to do a calculation if there is an empty field

Post

Hello. I am new to calculations and am struggling. Here is the situation. I have a field name "PreferredName". I would like that information filled with the "company name" field data if it is not empty. If the "companyname" field name is empty, then I would like the "preferredname" field to be filled with the data from the "z_fullname" field.

I am trying to put an If statement together but I don't know how to reference if a field is empty. Here is what I tried to do but it didn't work

Case (

Get (companyname) 

If (company name) is empty

Then

Get (z_fullname)

 

Thank you.

 

Outcomes