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

    summation of aggregate and value

    Rico de Feijter



      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.