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.