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:
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.