1 Reply Latest reply on Feb 27, 2018 5:38 AM by Rico de Feijter

    summation of aggregate and value

    Rico de Feijter

      Hi,

       

      I want to sum the following numbers:

       

       

      So, I want to add UNIT_LABOR_COST, which is 115,5 to the sum of Materiaal, which is 103,06. The result of this should be 218,56, which should be positioned under €103,06.

       

      However, I cannot mix aggregate numbers with non-aggregate numbers in a calculation, as for instance as follows:

       

      [UNIT_LABOR_COST] + sum([Materiaal])

       

      Is there a different way to achieve this?

       

      My workbook is attached and it concerns the OptionCalculationKForce sheet.