2 Replies Latest reply: Jul 30, 2012 4:18 PM by fdiazvega RSS

    avg with not equal (<>) condition

      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.