Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

Why is the output value 0?

=Aggr(if([Average] <= [Spec (Upper limit)] and [Average] >= [Spec (Lower limit)],1,0),Id)) 

and This 

=Sum(Aggr(if([Average] <= [Spec (Upper limit)] and [Average] >= [Spec (Lower limit)],1,0),Id))

Same this return is 0. 

Why is the resulting value not sum the value 1 return the loop if ?

0 Replies