Multiply the values of subsequent cells of table

[FedePrado]

Hello everyone, hope you all are doing fine!

I have just started to work on this awesome tool, and I have found my first problem hahaha.

I have a table in wich I am storing a PC name and a yield percentaje.

Table looks like this:

What I am trying to achieve here, is to be able to multiply the values on the Yield column: (0.9964 * 0.9930 * 0.9920 * 0.9872 * 0.9844)

Once I have that information, I need to show that in a donut chart.

I guess it has to be done with some sort of while or if loop, but I am not sure on how to do it.

Any help is very much appreciated.

Thanks!

[ImkeF · Accepted solution]

Hi @FedePrado ,

please check the PRODUCTX-function for this.

If you need help implementing this, please share more details, i.e. if you want a cumulative approach, what the order is, if "Yield" is a measure or a column...

[FedePrado]

Hi @ImkeF !!!

Thanks for your reply, I will look on that function right away!

I am working on a report that based on some filters shows information about yiels and yars of ome production lines, the first graphic tht is shown is a Yield graphic, lets call it "genelra yield" for all the stations in a selected production line. This is the graphic that I am trying to create here.

I am already showing the yields per station as shown in the screenshot I shared, the Yield information shown on the screenshot is a measure that is calculated using two columns of a table that is called Yield also.

In short, I just need to find a wey to multiply the values of the Yield measure one by one, to get the value for the "general yield" graphic.