Compare Previous Expression

[#1]

Hi Guys,

I need to arrive at the total count of the values based on the previous expression.

Attached is the sample Excel & the Desired output as well.

Can some1 help me in this

Rgds,

srini

[Gysbert_Wassenaar · Accepted solution]

Try: if(amt>=20,count({<amt={'>=20'}>} total amt),0)

See attached qvw

[#3]

BINGO 🙂

[#4]

just one help,

is it possible to count the same no of rows, if the second Expression ("Yes/No") = 'Yes' as per my excel.

i.e, can i get output something based on below

Column(2) = if(amt>=20,'Yes','No')

count(if(column(2)='Yes', count(rowno()))

Rgds,

srini

[#5]

Hi,

i have done it @ Script itself..

Rgds,

srini