0

Format Number 0.00

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.

1 comment

Post is closed for comments.