The sum of the 2 tables is not equal

[Paknanarn23]

I have entered the code But the total results are not equal.

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

[Mark_Little]

HI @Paknanarn23 

It will be down to aggregation. Take a look AGGR function.

You will need to make the the calc is being done at the correct level in the top level.

[Paknanarn23]

Hi Mark

I did, the sum is not correct. Can you have the code for me?

[vinieme12 · Accepted solution]

=AGGR(  if([Average] <= [Spec (Upper limit)]
and [Average] >= [Spec (Lower limit)],1,0), [Panel ID])

[Paknanarn23]

Hi Vineeth 

I've tried that and the values still don't match.