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.
Never mind. Found it by positioning Total Cost in the marks section and using the following formula:
sum([Materiaal]) + attr([UNIT_LABOR_COST]).