AnsweredAssumed Answered

How to ignore empty fields in calculations

Question asked by facaylar on Dec 29, 2015
Latest reply on Jan 11, 2016 by facaylar

Hello fellow devs, I'm hoping one of you can give me a clue as to how to write a particular calculation.

 

Our database is used to track user information and has several fields:

 

  • Name
  • Address_1
  • Address_2
  • Address_3
  • Address_4
  • City
  • State
  • County
  • Postal_Code
  • Country

 

Since Addresses in the United States are all the same, the calculation to truncate them is easy. However, my international users, being from different countries, have addresses that don't necessarily conform to the US standard.

 

Is there a calculation that will go through each field and only feed fields into the calculation that have data in them? Let me know if I need to clarify.

Outcomes