Skip to Content
avatar image
Former Member

Adding values

Hi

I have idoc to file scenario. Purchase order idoc. I want to add the line item values and populate a field on the header structure.

Line item 10 100£

Line item 20 100£

Line item 30 200£

The field in the header is sum_item_value. The result after mapping should be 400£ in this field.

How do i acheive this using the mapping editor.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 23, 2012 at 12:41 PM

    use SUM function under " Statistic" category

    chk below mapping:

    Input( change its context to parent node)----
    Constant(£)---------------------------------ReplaceString----SUM-
                                                     /              ---concat-----sum_item_value
                                                     /      Constant(£)--/
    Constant()-------------------------------------/
    
    

    Edited by: AmitSri on Jan 23, 2012 6:40 PM

    Add comment
    10|10000 characters needed characters exceeded