StringToDecimal - behavior with direct Arith ops
Posted: Mon Sep 04, 2006 5:53 am
Hi,
I am trying following:
I am getting a column TRAN_AMT. This amount am reading as string from file.
The amount is spaces sometimes which indicates it is 0.
Now I have to generate three columns AmtPls8(as TRAN_AMT +
and AmtMult8 (as TRAN_AMT * .
If while deriving above columns, I directly use the derivations as:
With input as spaces, I am getting the output for the cols as 000123456754.12 and 000987653968.99 respectively whereas actual output should be 8 and 0.
Now I tried a bit diff approach to it. I added one stage variable AmtSVar and code is changed as follows:
After this the result was 000000000008.00 and 000000000064.00 respectively meaning for first col the result is OK and during the second calc it again behaves strangely.
Then I change the cols to have derivations as:
After this am getting proper results.
One more thing if the incoming column value is proper number and not spaces, then everything works fine and no need for the stage variable. But if it spaces, then it needs stage var to make the logic work proper.
I am trying following:
I am getting a column TRAN_AMT. This amount am reading as string from file.
The amount is spaces sometimes which indicates it is 0.
Now I have to generate three columns AmtPls8(as TRAN_AMT +
and AmtMult8 (as TRAN_AMT * .If while deriving above columns, I directly use the derivations as:
Code: Select all
AmtPls8 = StringToDecimal(TRAN_AMT) + 8
AmtMult8 = StringToDecimal(TRAN_AMT) * 8Now I tried a bit diff approach to it. I added one stage variable AmtSVar and code is changed as follows:
Code: Select all
Stage variable:
AmtSVar = StringToDecimal(TRAN_AMT)
Cols Derivation:
AmtPls8 = AmtSVar + 8
AmtMult8 = StringToDecimal(TRAN_AMT) * 8Then I change the cols to have derivations as:
Code: Select all
AmtPls8 = AmtSVar + 8
AmtMult8 = AmtSVar * 8One more thing if the incoming column value is proper number and not spaces, then everything works fine and no need for the stage variable. But if it spaces, then it needs stage var to make the logic work proper.