Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I am trying to count nos of the following but getting no rows count, what am i missing?
=SUM({<Status={'A Camb'},{'A Birm'},{'A Hurn'},{'A Irl'},{'A Cumb'},{'A Brig'}>}1)
Hi,
there's a parenthesis missing,
count({<Status={'A Camb','A Birm','A Hurn','A Irl','A Cumb','A Brig'}>} Status)
Regards,
Brice
Maybe try it like
=count{<Status={'A Camb','A Birm','A Hurn','A Irl','A Cumb','A Brig'}>} Status)
hI Swuehi,
I am still not getting any record back.
The syntax of swuehl is correct - so there's either a spelling error of your field Status (note, it's case sensitive) or one of your values 'A Camb' etc. is misspelled or does not exist. However, in the latter case, you should've gotten at least a number as a result.
Hi,
there's a parenthesis missing,
count({<Status={'A Camb','A Birm','A Hurn','A Irl','A Cumb','A Brig'}>} Status)
Regards,
Brice
Very attentive - I missed it.
Thanks all, you all rock