cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
bdr_jmp_team
Level III

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

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

Many different options for this, here is one

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

jthi_0-1653297802292.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

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

Many different options for this, here is one

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

jthi_0-1653297802292.png

 

-Jarmo
bdr_jmp_team
Level III

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

Hi jthi

 

Thanks works like a charm