Set analysis

[#1]

Hello I am trying to get the last value (%Realizado) of an indicator without selecting anything, I have these set analysis:

=avg( {<Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado), with this one I have the average score for all dates, but I want ti get only the last one, how can I this whitout selecting a date or an "Indicator"?

Thank you!

[#2]

Normal 0 21 false false false FR X-NONE X-NONE

Hi

try something like this :

=avg( {< Date={'$(=max({1}Date))'} , Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado)

Normal 0 21 false false false FR X-NONE X-NONE

{1} means independant of the selection

What means %Realizado ? Be careful if it's a percentage, because you maybe calculate a mean of percentage.

JJJ

[#3]

Hello, thank you for your quick response, I did this

=avg( {<Semana={"$(=max({1}Semana))"} , Indicador= {'Gastos Totales vs Presupuesto'} >} %Realizado)

But is not working....