Format Number 0.00

David Paras

• November 12, 2015 20:15

I have this formula in my mapper, and it's working for all values in my source data except 0.0 - any ideas?

VALUE=[format-number(format-number($Input_TestSchema/DB/payroll_changes/NewDeduction,'#.##'),'0.00')]

It is rounding to 2 places, then formatting to add a decimal in front and in back...so it takes 0.5 and converts it to 0.50...and that's working, but I get an NaN in the data when I put in 0.0.

0

• 

  David Paras

  • November 12, 2015 20:16

  Try replacing the #s within the first format number with 0s.

  VALUE=[format-number(format-number($Input_TestSchema/DB/payroll_changes/NewDeduction,'0.00'),'0.00')]

  0

Post is closed for comments.