How do I write a rule to replace values for a column (dependent on another value)
I am trying to use Rule Engine Node to write a rule to replace Purchase column from value 0 to 1 when Total Spend column is > 1. But I was unable to do so, can anyone advice.
I have tried this expression but it is not working
$Purchase Count$ = “0” AND $Purchase Indicator$ = “0” AND $Total Spend$ >= “0.01” => “1”
TRUE => “0”