10 Replies Latest reply on Oct 16, 2016 5:53 AM by wimdecorte

    Skip or Omit ... potential pitfall

    David Moyer

      I propose to you the following:

      Two bits of code - I think the first one is fine, I think the second one has the potential for problems:

      First, a walk in the park ...

      Then, enter the Twilight Zone ...

      Capture.PNG

      Given a set of five records, if the fifth (last) record meets $condition=1, then the previous existing record's Main::OrderTotal will be evaluated twice and $grandTotal will be incorrect.  I recommend the following modification to the "Omit Record" step ...

      Capture.PNG

      Addendum:

      - the Set Variable $condition was intentionally left empty.  It should say // your Boolean logic here