8 Replies Latest reply on Jul 31, 2018 3:38 AM by P B

# Row Values Multiplication

Greetings,

I am calculating Yield by using the following pattern: SUM([Passes]) / SUM([Quantity])

With the following data set: Normally I would use this method (Based on excel's product function): Running Product but, I just want to display the outcome in a single cell (43%) rather than all the rows and columns and put it in the corner of my dashboard.

Is that possible? I tried to use running product, but when i remove Test and Product it shows 95% when in fact it should show 43% • ###### 1. Re: Row Values Multiplication

Hello 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

1 of 1 people found this helpful
• ###### 2. Re: Row Values Multiplication

You can try this,

{FIXED [Test]: SUM([Passes])} / {FIXED [Test]: SUM([Quantity])}

Let us know if this help.

Mahfooj

• ###### 3. Re: Row Values Multiplication

Hello Mahfooj,

I changed [Yield] calculation to {FIXED [Test], [Product]: SUM([Pass])} / {FIXED [Test], [Product]: SUM([Qty])} but seems like the numbers are bit off.

After this changed, I had to change [Running Yield] so that it aggregates [Yield] and the final outcome looks like this: • ###### 4. Re: Row Values Multiplication

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

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.

• ###### 6. Re: Row Values Multiplication

Hi,

Is that what you wanted? Workbook attached for your reference. Let us know if this help.

Mahfooj

• ###### 7. Re: Row Values Multiplication

Great, thank you. That did the trick.

• ###### 8. Re: Row Values Multiplication

Thanks!