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

david_smee — Tue, 11 Jul 2023 20:58:34 GMT

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?

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

david_smee — Wed, 12 Jul 2023 12:27:29 GMT

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