count matching values in a collumn

[#1]

Count((MsgType)=(census))  as you know this does not work.

My field has 5 different values I am creating a table to display Facility month year and Census, Newrx, and three other.

How do I count only one of the five in each column?

[trdandamudi]

It should be as below:

Count( {<MsgType={'census'}>} census)

Count( {<MsgType={'Newrx'}>} Newrx)

[#3]

This is what I have but it only counts 1

Count( {<MsgType={'NEWRX'}>} 'NEWRX')

[trdandamudi]

I don't have any data to tell you what is wrong... Can you please upload a sample app with expected output so that we can take a look.

Note: You have extra quotes at the end, so remove them. It should be as below:

Count( {<MsgType={'NEWRX'}>} FieldName)

[vishsaggi]

Try this:

Without quotes for the field name and is your field name all capitals or like this Newrx ?

Count( {< MsgType = { 'NEWRX' } >} Newrx)

[sunny_talwar · Accepted solution]

How about this:

Count({<MsgType={'NEWRX'}>} MsgType)

[Anonymous]

Send a qvw example

[vishsaggi]

My bad, Thanks for catching this Sunny.

RObert please use sunny's expression. It should work.

[#9]

[sunny_talwar]

Did you try this?

Count({<MsgType={'NEWRX'}>} MsgType)