You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

#NoData to Zeros

Received Response
edited Nov 13, 2019 8:18AM in Financial Consolidation and Close 3 comments


Code Snippet for changing No data fields in forms into Zeros


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!