Page 1 of 1

Percentage in Transformer

Posted: Mon May 14, 2007 1:10 pm
by travissolt
I am trying to do a simple division step in the transformer but the result is zero for anything that is not a whole number. The output field is set to handle decimal (10,2). For testing purposes I had it try simple stuff like 31/31 and it gave me 1
10/2 and it gave me 5
100/50 it gave me 2.

Any other fraction failed 1/2,5/7 etc.... Its too simple not to be able to done in this step so I must be missing something. Thanks

Posted: Mon May 14, 2007 3:14 pm
by travissolt
Finally figured it out use ASFLOAT(1)/ASFLAOT(2) to get .5.