avg with not equal (<>) condition

[#1]

Hi everyone,

im having troubles when adding the "not equal" condition on avg sentence.

my actual expression is:

=Avg( {$<Año = {$(#=Max(Año))}, idCriterio=, K1={'14'} >} Valor)

when i try replacing the "equal" (=) with "not equal" (<>), it doesnt work.

=Avg( {$<Año = {$(#=Max(Año))}, idCriterio=,K1<>{'14'} >} Valor)

Any suggestion?

many thanks in advance.

[claudio_pochett · Accepted solution]

Hello

Try this:

=Avg( {$<Año = {$(#=Max(Año))}, idCriterio=,K1 = K1- {'14'} >} Valor)

[#3]

It works perfect, even for string values.

Thanks a lot