I want to create a column that gives a Yes/No answer if another field (numeric) is not null. For example, if a sales count returned 515, I’d want a “Yes†to indicate that there were sales, else a “No†to indicate no sales.
.
I have tried IF (
.[COUNT] is not null) then (‘Yes’) ELSE (‘No’), but I get an error when I run the report.
|