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

bdr_jmp_team — Sat, 10 Jun 2023 23:48:46 GMT

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

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

jthi — Mon, 23 May 2022 09:23:33 GMT

Many different options for this, here is one

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

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

bdr_jmp_team — Wed, 01 Jun 2022 15:49:16 GMT

Hi jthi

Thanks works like a charm :)

topic Re: How to use Summary Function without creating a new table with column formulas in Discussions

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

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

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