Counting rows that meet a condition in a table

[stvn_003]

Hello, I have a question, you can count the rows displayed in a table, and you can count the rows that meet a condition, in my case, all that in the "A" are zero

Already, thanks for the help

[sunny_talwar · Accepted solution]

Count in a text box could be performed using the following expression:

=Sum(If(Aggr(Count({$<ocd_precio_ok = {N} >} ocd_cmtrlsap)  - Count( {$<ocd_precio_ok = {N}, occ_fentr = {"<=$(=Date(Today()-7,'DD/MM/YYYY hh:m:ss tt'))"} >} ocd_cmtrlsap), ocd_cmtrlsap, ocd_tmtrlsap, occ_cgrsp) = 0, 1, 0))

HTH

Best,

Sunny