Average of a range of data

[#1]

Hello Everyone,

I'm trying to calculate in a KPI the average of only data that are above 46400 kilograms. (Peso Bruto), i don't need the average of the whole table.

Regards,

Gerd Neumann.

[paul_scotchford · Accepted solution]

avg(if(weight>46400,YourFieldToAverage))

or using set analysis

avg( {$<weight={">46400"}>} YourFieldToAverage )

[jagan]

HI,

Try using set analysis like below

=Avg( {<[Peso Bruto]={">46400"}>} [Peso Bruto])

Hope this helps you.

Regards,

Jagan.

[#4]

This works for me.

Regards,

Gerd Neumann