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)?
Solved! Go to Solution.
Do not use [_THISROW]
in your IF() expression.
Do not use [_THISROW]
in your IF() expression.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |