[Validation & Line Loop & Macro] How to calculate the total quantity of a document

• 

  george harris March 29, 2016 13:09

  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

  0

  Comment actions Permalink
• 

  Naama Aharoni March 30, 2016 07:53

  Hi George,

  Please try to replace the NUMBER with CURRENCY.

  Thanks, Naama

  0

  Comment actions Permalink
• 

  george harris March 30, 2016 08:28

  Instead of
  set($[$BOYX_5.0.Number]|$[LLRESULT.Number]);

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

  and it works!!
  Thank you!

  0

  Comment actions Permalink
• 

  Adam Hunniford January 24, 2018 12:30

  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?

   

  Thanks

  0

  Comment actions Permalink
• 

  Sarah Swettlen March 20, 2019 20:14

  Hello,

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

  0

  Comment actions Permalink

Please sign in to leave a comment.