cancel
Showing results for 
Search instead for 
Did you mean: 
marcol
Nintex Newbie

"String format" formula to display '0'

Hello

 

I'm using the "string format" function in Nintex Forms in order to format a single line textbox as a currency field. The formula I'm using is 

#,##

This works fine. But if the field value is '0' the form doesn't display anything, it's just empty.

 

Does anyone know, if I can change this formula somehow to still showing '0'?

Labels: (1)
0 Kudos
Reply
1 Reply
mlauer
Nintex Newbie

Re: "String format" formula to display '0'

try 0,00

 

from Nintex Forms Help:

String Format: The string format to apply to the value. The string format will be determined by the type of data specified by the control. When it is a number the following can be used http://msdn.microsoft.com/enus/library/0c899ak8.aspx, and http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx. For other types see http://msdn.microsoft.com/en-us/library/26etazsy.aspx

0 Kudos
Reply