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

Follow

Comments

3 comments

  • 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
    set($[$BOYX_5.0.Number]|$[LLRESULT.Number]);

    I used
    set($[$BOYX_5.0.CURRENCY]|$[LLRESULT.Number]);

    and it works!!
    Thank you!

Please sign in to leave a comment.

Powered by Zendesk