6 Replies Latest reply on Jan 3, 2018 7:25 AM by Nai Louza

    Please help - what is the right formula? (a specific sum)

    Roland Zimmermann

      Hello,

       

      my experience in formula usage is limited ;-) Please help.

       

      In the attached screenshot you see a formula that comes up with 1 if the value of an "order line" is > 50000. That is easy.

      But what I need is a formula that comes up with 1 if the value of the whole "purchasing document" (consisting of several "order lines") is > 50000.

       

      Can somebody tell me what the formula must look like?

       

      Thank you in advance,

      Roland

       

      screenshot1.png