Sample: Automation - How to calculate the total quantity of a document




  • Avatar
    george harris

    I have tried this and it works for integers but not for floats.
    Below message occours when the QTY is not an integer.
    Message: Macro error in UF-036: System.Exception: Input string was not in a correct format.
    [Macro Command: set($[$BOYX_5.0.NUMBER]|2.5)]

    Macro Enviroment parameters:
    [Current Form: 140 - Delivery]
    [Source Row: 2] [Target Row: 2] [Break: False] [Initial

  • Avatar
    Naama Aharoni

    Hi George,

    Please try to replace the NUMBER with CURRENCY.

    Thanks, Naama

  • Avatar
    george harris

    Instead of

    I used

    and it works!!
    Thank you!

  • Avatar
    Adam Hunniford

    Rather than start a new thread, since my problem is the same, I thought it wise to ask here.

    Fundamentally I have the same issue but the 'currency' fix did not work. It removed the error but the value is not written to the UDF. I am testing where the value is 599.8. I tried changing to currency in the line loop final result but this doesnt change anything. Do I need to change the UDF type? There are a bunch of other options but I am unsure which is best.


    Can anyone advise?



  • Avatar
    Sarah Swettlen


    How would you filter this out to only total the quantity for specific items?

    Thank you

Please sign in to leave a comment.