Set Analysis problem with last year

[#1]

Hi Dear Community

I have this problem with set analysis, i have this expression

Money((Sum({<Año={$(#=Only(Año)-1)}>} Valor_PyG/$(vMoneda_PyG))/If(GetFieldSelections(MONEDA)='COP',1000000,1000))

The expression works fine with one ore more month selected but if i don't have months selected the value is zero.

[swuehl · Accepted solution]

Do you get an unambiguous value for Ano if you don't have months selected (watch field list box Ano while selecting / unselecting months)? I assume your only(Ano) is returning NULL.

Hope this helps,

Stefan

[#3]

I solved my problem add this part in set analysis Mes ,Mes={"<=$(vMaxMes)"} Thanks For all