3 Replies Latest reply: Jun 8, 2012 6:43 AM by ioannis giakoumakis RSS

    This is a tricky one...

    ioannis giakoumakis

      Hi all.

      I need to make a complex calculation, preferably as a variable.

       

      I have made it by using a straight table, but now I need to convert it to a single formula. The desired result is the sum of rows of column Final (see attached QV file). What I want to achieve is having the user type in a QTY (variable) and use this quantity in the calculation. But this quantity needs to be only used once in the cummulation done in column 3.

       

      Please see attached QV, it will make the case clear.

       

      Thank you for your help.

      giakoum