Forum Discussion
Using 'product' function by group
Hi,
With original Table 1,
First, I would like to multiply Rate% by the same WO no. From Table 1; I am not sure which fomular I should use such that only multiply for the same group in WO column.
Then, I would like to average Yield % in Table 2 by the same WO no.
Please advise fomular I should use.
Anonymous
Not sure if I correctly understand, but please try
Yield % = VAR T1 = SUMMARIZE ( TableName, TableName[WO], TableName[Product], "@Yield", PRODUCT ( TableName[Rate] ) ) RETURN AVERAGEX ( T1, [@Yield] )
4 Replies
Anonymous
Not sure if I correctly understand, but please try
Yield % = VAR T1 = SUMMARIZE ( TableName, TableName[WO], TableName[Product], "@Yield", PRODUCT ( TableName[Rate] ) ) RETURN AVERAGEX ( T1, [@Yield] )Hi Anonymous
do you have relationships between the two tables? Can you clarify? I assume you want (1.0 x 1.0 ) x (1.0 + 1.0)/2 is that correct?
Good morning everyone.
Has anyone ever made an application in Visual Studio (Vb.net) to open a Gravico or destbord in the form of an application. And would you have some example to send me Or could you describe how it was done.Good morning everyone.
Has anyone ever made an application in Visual Studio (Vb.net) to open a Gravico or destbord in the form of an application. And would you have some example to send me Or could you describe how it was done.
