Count of invoices begin with CIN

[Manisha1407]

Hello Team,

I have a field name as Invoice with the following invoice numbers:

Invoice

CIN202021

RIN218181

CIN202021

CIN211202

RIN237111

SMR103011

I want to make a count of all invoices begin with CIN and RIN and SMR.

Thanks

[hic · Accepted solution]

Count({<Invoice={"CIN*","RIN*","SMR*"}>} Invoice)

or make a chart with Left(Invoice,3) as dimension, and use Count(Invoice) as measure.

[Manisha1407]

Thank you so much!!

It worked for me.