
1. Re: Row Values Multiplication
Hildebrando Souza Jr Jul 30, 2018 7:06 AM (in response to P B)1 of 1 people found this helpfulHello PB,
Just create a calculated field with the table calculation LAST()=0. This will result in a Boolean that is true when you have the last value of your partition. Now put this new calculated field on the Filter Shelf and filter "True" (make sure that your table calculation is addressed to Test and Product). Now just move Test and Product to Detail on the Mark Shelf. Now you are good to go.
Best,
Hil

2. Re: Row Values Multiplication
Mahfooj Khan Jul 30, 2018 7:15 AM (in response to P B)You can try this,
{FIXED [Test]: SUM([Passes])} / {FIXED [Test]: SUM([Quantity])}
Let us know if this help.
Mahfooj


4. Re: Row Values Multiplication
Mahfooj Khan Jul 31, 2018 12:17 AM (in response to P B)Could you please provide some sample mock up in packaged workbook with your expected output? It'll help us to give you solution.

5. Re: Row Values Multiplication
P B Jul 31, 2018 12:41 AM (in response to Mahfooj Khan)Hi Mahfooj,
Please find it attached. In there you can find data: Test, Products, Passes and Quantity. In the workbook we calculate [Yield] with sum of [Passes] / [Quantity] and then we calculate Running Yield with EXP(RUNNING_SUM(LN([Yield]))). The final outcome is in the other sheet. I would like to display the last value of Running Yield, which is basically [Yield] of every [Test], [Product] multiplied.

Yield.twbx 46.7 KB


6. Re: Row Values Multiplication
Mahfooj Khan Jul 31, 2018 2:56 AM (in response to P B)
Yield_v10.2.twbx 48.3 KB


7. Re: Row Values Multiplication
P B Jul 31, 2018 3:37 AM (in response to Mahfooj Khan)Great, thank you. That did the trick.

8. Re: Row Values Multiplication
P B Jul 31, 2018 3:38 AM (in response to Hildebrando Souza Jr)Thanks!