Originally posted by: SystemAdmin

In the rules, I am able to do a sum on one field such as: =NUMBERTOTEXT( ROUND(SUM( TEXTTONUMBER(Merchandise_Amt_124 Field:Lines Record:VchrDtl:HdrCalcIn) ),2))

but not on two fields such as:
=NUMBERTOTEXT( ROUND(SUM( TEXTTONUMBER(Merchandise_Amt_124 Field:Lines Record:VchrDtl:HdrCalcIn) ),2) + ROUND(SUM( TEXTTONUMBER(Vat_entrd_amt_ln Field:Lines Record:VchrDtl:HdrCalcIn) ),2))

Is this the correct way of adding 2 fields or what need to be modified? Any help will be appreciated. Thanks!
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Try this version ... I think you are missing a SUM around the two objects.

=NUMBERTOTEXT(SUM(ROUND(SUM( TEXTTONUMBER(Merchandise_Amt_124 Field:Lines Record:VchrDtl:HdrCalcIn) ),2) + ROUND(SUM( TEXTTONUMBER(Vat_entrd_amt_ln Field:Lines Record:VchrDtl:HdrCalcIn) ),2)))
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I don't know if this will work, but try to only do one Round & Sum of the two values added together.

code:1:9aa83b3f8c=NUMBERTOTEXT(
ROUND(
SUM(
TEXTTONUMBER(
Merchandise_Amt_124 Field:Lines Record:VchrDtl:HdrCalcIn
)
+ TEXTTONUMBER(
Vat_entrd_amt_ln Field:Lines Record:VchrDtl:HdrCalcIn
)
)
,2
)
) [/code:1:9aa83b3f8c]

John
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Thanks for the replies! Jennifer that worked!
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange