How to Load Zeros Through Data Load Rules to Reflect in a Template?
  • 1 Minute to read
  • Dark
    Light
  • PDF

How to Load Zeros Through Data Load Rules to Reflect in a Template?

  • Dark
    Light
  • PDF

Article summary

Loading zeros through the Data Load Rules will not reflect 0 in the template. If you want data in a template to display as a zero (0) versus a dash (-) in a template, load 0.000001 (1 as a sixth decimal) versus 0 via Data Load Rules. The Data Load Rule will indicate data was successfully loaded and the values will be shown when the template is opened.

Note:
This functionality behaves as it does because 'zero' is not recognized as a value.

The values in a template can be zeroed manually as well.


Was this article helpful?