count values and null in expression

[nicolai_moller]

Hi

In my sample data I want to write an expression that counts all cases where the field 'Exp' doesn't end with 1 or 0.

I would also like the expression to return cases with empty values in the field 'Exp', so the sample data should give me 3 cases (2, 3 and 5)

Thanks

Sample data:   

case	Exp
1	5|1
2	4|2
3	3|3
4	3|0
5

[YoussefBelloum]

Hi,

try this on your exp expression:

=Count({<Exp={"=not match(right(Exp,1),'1','0')"}>} 1)

[jaumecf23]

Hi,

Try this.

Expression 1 : =count({<Exp-={"*|0","*|1"}>}case)

Expression 2 : =concat({<Exp-={"*|0","*|1"}>}case,',')