xlate math function – multiplication of a numeric field

[Cynthia Briscoe]

I have a field for quantity in an hl7 message that I want to use the math function multiplication on to multiply the field by two.  I do not know how to use this.  I have put the field 0(0).FT1(0).00364.[0]*2 and have also tried 0(0).FT1(0).00364.[0]*(2) but it still is keeping the original quantity.  Is there a specific nomenclature or format for indicating what you want the specific field multiplied by? 😥

Topic

[Jim Kosloskey]

Cynthia,

In your Source coulmn put:

0(0).FT1(0).00364.[0]

=2

Select MATH an MULTIPLY – it will multiply all of the elements in the Source list putting the reult in the Destination List elemen (probably will only have one element).

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Cynthia Briscoe]

Perfect!  That works great!  I was so close it was frustrating!  Thank you, Thank you, Thank you!! 😀

[Author]

Replies