Hi
I have a table for scrap data.
A production unit (VE) with a target value goes through different production steps and that's why given the production unit id many times in original table in order to give scrap details for every production unit. (The table is shortend for anonyminity)
What is needed is a formula that sums up different production unit target values once and gives the total production target value (8131) for all different units in a column but in same table as original table. How can i do this? column sum(column mean(ve_soll, ve)) is not working as expecting.
Work around I found is to create a summary table and join the calculated value back in original table.
I am looking for a mathematical formula that calculates this without need for summary table.
Thanks in advance
Kind regards
Günes