Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello
Try this:
=Avg( {$<Año = {$(#=Max(Año))}, idCriterio=,K1 = K1- {'14'} >} Valor)
Hello
Try this:
=Avg( {$<Año = {$(#=Max(Año))}, idCriterio=,K1 = K1- {'14'} >} Valor)
It works perfect, even for string values.
Thanks a lot