4 Replies Latest reply on Sep 5, 2014 12:51 PM by PatriciaAngelini

    How to do a calculation if there is an empty field

    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.