Hello ,
I have a requirement to convert the decimals values (generated as an output of aggregator ) to standarformat of xx.xx.
Example :
.32 -> 00.32
-1.5 -> -01.50
8 -> 00.80
I can do this in sql query , but as soon as the data gets processed by datastage aggregator , the decimal formatting just vanishes .
Any help appreciated .
Decimal formatting
Moderators: chulett, rschirm, roy
Decimal formatting
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane