8 Replies Latest reply on Dec 5, 2016 10:10 PM by Sireesha J

# How to do Group multiplication

Hi Friend ,

Seeking your support to find the RTY(rolled throughput yield) calculation

Sample data attached in Excel sheet.

Main groupSubgroupTestedPassedYield
Filter testFilter-1 teste37436296.8%
Filter-2 test34932492.8%
Filter-3 test38437397.1%
Module testeMFT test28326794.3%
PA test64257789.9%
OGI testVI test325325100.0%
VI1 test34834198.0%
VI-2 test33832596.2%
Unit testUnit teste34529585.5%

I would like calculate in the below format

Subgroup test: Sum of all individual tested of subgroup( ex: filter1+ Filter2+filter3)

Subgroup yield : Subgroup passed/subgroup tested

RY : Multiplication of all subgroup yield ( 95.75*91.2%*98%* 85%)=73%

Main groupSubgroupTestedPassedYieldSubgroup testedSubgroup passedSubgroup yieldRTY
Filter testFilter-1 teste37436296.8%1107105995.7%73.16%
Filter-2 test34932492.8%
Filter-3 test38437397.1%
Module testeMFT test28326794.3%92584491.2%
PA test64257789.9%
OGI testVI test325325100.0%101199198.0%
VI1 test34834198.0%
VI-2 test33832596.2%
Unit testUnit teste34529585.5%34529585.5%
• ###### 1. Re: How to do Group multiplication

Hi Nagesh!

Check the attachment for the solution you have asked for.

You need to split all the calculations separtedly at Main Group level to do group a calculation.

• ###### 2. Re: How to do Group multiplication

Hello Nagesh,

I've created a workbook which just satisfies the above scenario if you add multiple records to the existing data set the result may not be correct.

Please find the below attached workbook.

Regards,

Sudhakar

• ###### 3. Re: How to do Group multiplication

Hi Sireesha ,

Thanks ,it is working.. Just to add on if the data is varying on date wise( Month) , then this method will not work out...could you help to find out the same.

Sample:

If I have the data for month P07 and P08 ,then I have calc RTY for both individual month and overall RTY as well.

• ###### 4. Re: How to do Group multiplication

Hi Nagesh!

Attached new file for the new requirement. Hope it resolves your issue.

You need to modify the data format for the new requirement.

Regards,

Sireesha.

• ###### 5. Re: How to do Group multiplication

Hi Sireesh ,

You might be attached the old .twbx file... could you please share the modified file.

Thanks

Rg,

• ###### 6. Re: How to do Group multiplication

Hi Nagesh!

Sorry for the previous post. Now, check the attachment.

Regards,

Sireesha.

• ###### 7. Re: How to do Group multiplication

Hi Sireesh ,

It is working ,Thanks a lot

• ###### 8. Re: How to do Group multiplication

Hi Nagesh!