Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the expression for Pass/Fail in the table or is this a field from the script?
the expression in if statemnet that include more varibles
What is it though?
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))))