Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i Count ID if the NAME start with 'A'.
I try this expression
Count( if Name = 'A*' , ID )
but it s not working
Try:
Count({<Name={'A*'}>} ID)
COUNT(IF(Name Like 'A*', ID))
Count( if( Name Like 'A*' , ID ))
try like this
aggr(if(name='A*')i,d)
Count( if( Wildmatch(Name,'A*') , ID ))
Or
Count( if( Left(Name,1) = 'A' , ID ))
Thanks