Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count({<Invoice={"CIN*","RIN*","SMR*"}>} Invoice)
or make a chart with Left(Invoice,3) as dimension, and use Count(Invoice) as measure.
Count({<Invoice={"CIN*","RIN*","SMR*"}>} Invoice)
or make a chart with Left(Invoice,3) as dimension, and use Count(Invoice) as measure.
Thank you so much!!
It worked for me.