Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
#NoData to Zeros — Cloud Customer Connect
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
18
Views
3
Comments
edited Nov 13, 2019 8:18AM in Financial Consolidation and Close 3 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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