The if does not work correctly

[Sandro_Ingrao]

I have generated a column a virtual Enum column that returns “yes” or “no”:
LOOKUP ([_ THISROW]. [IDRECEIVED], "RECEIVED", "IDRECEVIED", "MACHINERY")

Then I generated another virtual column:
IF ([_ THISROW]. [MACHINERY] = "YES", [_ THISROW]. [PRICE] * 0.4, [_ THISROW]. [PRICE] * 0.7)

The table contains 8 records: 4 yes and 4 no, but the final calculation returns only the first part of the if (if true). Without distinction between yes and no.

Why do you think it doesn’t elaborate the second part of the if (if False)?

[Steve · Accepted solution]

Do not use [_THISROW] in your IF() expression.