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

    Row Values Multiplication

    P B

      Greetings,

       

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

      With the following data set:

      1.png

      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%

      2.png

       

      Thanks in advance!