Multiplying by a specific cell in a table

Drece-gkn — Tue, 13 Feb 2024 18:53:44 GMT

Hello,

First let me show you the screenshot of my table to help get a understanding of my data.

To the left of total sales(a) are Part numbers but I am not allowed to show those. In order to explain what I am trying to accomplish I will call the 3 part numbers A, B and C. Part number A = $857,004(Total Sales), but I need to split this cost between the 3 parts and put that cost in the new column "Consumption". I successfully split the total sales for part number A using the equation If([Material Number] = 'A', [Total Sales]*.6, which equals that $514,202.40 number you see. But I have not been able to figure out how to split it for B and C. Basically, for part number B and C I need to multiply the Total sales of part number A by .4. The equation I was trying to use was If([Material Number] = 'B' or [Material Number = 'C', if([Material Number] = 'A', [Total Sales]*4,' '))), but this does not work. I know the nested If isn't correct but I haven't been able to figure out the logic I need to use to solve this. Any Ideas?

Re: Multiplying by a specific cell in a table

vinieme12 — Wed, 14 Feb 2024 03:18:47 GMT

can you post some sample dummy data with expected outputs?

Re: Multiplying by a specific cell in a table

Drece-gkn — Wed, 14 Feb 2024 13:31:01 GMT

Expected results would be for Material Number A $857,004(Total Sales) *.6 = $514,202.4. Then for Material Number B and C we want to take the Total sales of A ($857,004) *.4 = $342.801.6. So, I would expect that total to show up in the consumption column for the Material Number B and C row.

topic Re: Multiplying by a specific cell in a table in App Development

Multiplying by a specific cell in a table

Re: Multiplying by a specific cell in a table

Re: Multiplying by a specific cell in a table