How to use Summary Function without creating a new table with column formulas

[#1]

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

[#2 · Accepted solution]

Many different options for this, here is one

Col Sum(:VE_SOLL / Col Number(:VE, :VE))

[#3]

Hi jthi

Thanks works like a charm