How to apply Sum(Total) in Final_New field

[nitin_007]

Hello All,

Final field is derived from Quantity * B.P, and in Final_New Field we want sum of final filed/sum of Quantity based on product. Below is the formula to derived the Final_New field.

=SUM(F2:F3)/SUM(D2:D3) 

Like wise for all the products.

Also attached the same data.

Thanks in advanced.

Regards,

Nitin

[Frank_Hartmann]

Maybe like attached

hope this helps

[sunny_talwar]

Try this

Table:
LOAD Plant, 
     Product, 
     Contract, 
     Quantity, 
     B.P,
     Quantity*B.P as final
FROM
[..\..\Downloads\Question_Community.xls]
(biff, embedded labels, table is Sheet1$);

Left Join (Table)
LOAD Plant, 
     Product,
     Sum(final)/Sum(Quantity) as Final_New
Resident Table
Group By Plant, Product;

[nitin_007]

Hi Sunny,

I want des output in front end expression.

[sunny_talwar]

What dimensions do you have in your front end table? Also, is final (field) calculated in the script or is that something which you need calculated in the front end too?

[nitin_007]

Dimensione field is  plant , Product, Contract.

final field is calculated in front end only, quantity*B.P=Final

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL <Plant, Product> Quantity*B.P)/Sum(TOTAL <Plant, Product> Quantity)

[nitin_007]

Hi Sunny,

Could you send me test.qvw application using my attached data.

[sunny_talwar · Accepted solution]

PFA

[Brett_Bleess]

Nitin, did Sunny's sample app get you everything you needed? If so, do not forget to come back to the thread to mark that post using the Accept as Solution button to give credit for the help you received, and to let others know that worked.  If you are still working on things, please leave an update.

Regards,
Brett