Replace ? with 0, >0 with 1.

Good afternoon. I am need to append a column with the value of 0 if “Sum(Counter)” is “?” and 1 if it’s any other number. I’ve tried rules engine and missing values. Can anyone help? Thank you!

image

Hi,
you can use the Rule Engine


1 Like

Excellent! Thank you. I figured it out just a few minutes ago. I appreciate your help.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.