Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a column called resident Type where i need to get sum of row which contains "-other" String but not "home -other " string .
Example:
Hotel -other
pg -other
home -other
home -other
Hotelwe -other
pgsds -other
i need to get sum as 4.
Now i am using below code but i get value 0. What i am doing wrong.
sum(if((wildmatch(resident Type,'*-other') and not wildmatch(resident Type,'home -other')),1,0)) = 0
Try this:
=Count({<[resident Type] = {'*-other'}-{'home -other'}>}[resident Type])
Try this:
=Count({<[resident Type] = {'*-other'}-{'home -other'}>}[resident Type])