Expand my Community achievements bar.

Passing a null value as 0.00

Avatar

Level 1

Please help ...

I have a form where I need to pass a null value as '0.00'.  I've tried playing with the binding:data pattern, binding:data format, value:default, field:display pattern, field:edit pattern and I still get a blank passed on my form.  Is there something else I can do?

Some of the patterns I've tried are?  Szzzzz9.99 and 9.99.

Thank you,  Kerri

2 Replies

Avatar

Former Community Member

If you define any display pattern on a numeric field that ends 9.99, the following script on the exit event will result in the value '0.00' for a null.

// form1.page1.nf::exit - (JavaScript, client)

if (this.isNull) {

     this.rawValue = 0;

}

Steve

Avatar

Level 10

You have to activate the check box to allow zero as value in the pattern.

Then pattern could look like

zero{z9.99}|num{z9.99}