Using a value from a column based on condition to create a new value.

[david_smee]

I am trying to get a value from a column based on a condition(row value) and use that to calculate a new value

I want to use the value in column B where column A Value = "A" and divide it into the value in Column B to create a new column

Example

Row 2 = 6.5 / 8.9 = 73.03

Row 3 = 3.5 / 8.9 = 39.32

Row 4 = 12/8.9 = 134.83

Any ideas how I can do this?

[david_smee]

Figured it out.  I created a variable and used the variable in the expression in the chart