DecimalToString

Raftsman · Post by **Raftsman** » Tue Feb 21, 2012 1:56 pm

My requirement is to convert a decimal to a string as follows;

001 = 1
002 = 2

but I need the following result for this one

000 = 0

I used the suppress_zero but end up with a NULL field. How do I go about keeping the 0

Thanks

DSguru2B · Post by **DSguru2B** » Tue Feb 21, 2012 2:28 pm

If Isnull() then zero else whatever.

Raftsman · Post by **Raftsman** » Tue Feb 21, 2012 2:34 pm

I am using a Stage Variable to setup the field as follows

IF IsNull(DSLink1208.SALARY_STEP_NUMBER) or DSLink1208.SALARY_STEP_NUMBER = '' THEN 'UM' ELSE DecimalToString(DSLink1208.SALARY_STEP_NUMBER,"fix_zero,suppress_zero")

I am getting 'UM' back when the source is 000.

qt_ky · Post by **qt_ky** » Tue Feb 21, 2012 6:30 pm

Like DSGuru2B suggested, change 'UM' to '0'.