I want to count the status of the line.
I defined the following -
CASE WHEN "Sales Order","Line Status" = 'Line Filled' THEN 1 ELSE 0 END
But the column is not populated at all.
There are Sales Order lines with status 'Line Filled'
Appreciate the help extended.
Not sure if it's just a typo in your post... but it should be "Sales Order"."Line Status"... it appears that you have a comma there when you should have a period.
Oh yes !!!
Thats a typo. But the formula I used in the RPD was correct.
Try Like instead of '='. It may works.. or equivalent operators to '=' (like, in, etc)