Count row in table

[Anonymous]

hi

I have table with fields and varibles.

I try to calculate two things:

1. Count only Pass rows ( Pass is varible, not a field)

2. Count all table rows.

I try using Aggr function but its not accruate...

Any idea?

Thanks

Ravit

[sunny_talwar]

What is the expression for Pass/Fail in the table or is this a field from the script?

[Anonymous]

the expression in if statemnet that include more varibles

[sunny_talwar]

What is it though?

[Anonymous]

for example:

if (ParamID=303 or (AVG(AVG_Val)=-1) or IsNull(ReportParamName),'Fail',

if (DashboardID=6 or DashboardID=7 or ParamID=120 or  ParamID=121,$(v4Pass),

if (ParamID=781 ,$(vFairnessPass),

$(v3Result))))