#NoData to Zeros

Summary

Code Snippet for changing No data fields in forms into Zeros

Content

Hello guys,

Could somebody please provide me an example of code snippet that would change empty fields into "0" when populating input forms. In my example, i have two accounts in columns and 5 custom movement members in rows. When user opens up a form and inserts values in f.e. 3 fields/intersections for the first account and leaves 2 blank fields for the same account, I would like these 2 fields to become 0 after running consolidation f.e. I need this for report purposes, because i have conditional formats that replaces values with zeros in cells that have No Data. Thats why