The pattern to control the display of a zero value has 3-parts, separated by a semicolon. Note the 2-semicolons:
positive_format;negative_format;zero_format To display nothing for a zero value, put nothing after the second semi-colon. So this display filter will show positive and negative numbers, but display nothing for a zero value when the object doesn’t have focus: ###,##0;-###,##0; > On Oct 3, 2017, at 5:59 PM, stardata.info via 4D_Tech <[email protected]> > wrote: > > In one listbox, i need to display a number format so if the value is zero not > display anything. > I try to insert the format ###.##0,##0 but not work properly. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
