YTD formula not working

[aresb]

hi everyone,

i have this formula

sum({<Year={$(=Only(Year))},Month= {"<=$(=max({<Year={$(=Only(Year))}>} [Month num.]))"}>}cod_connid_2_3_4_6_7_v)

which give me this result 

nevertheless the formula seems working with february data not including january results.

i should have 1540 but give me only february results.

Any idea on how to fix this ? 

[marcus_sommer]

Between 0 and rowno() is a comma missing.

[aresb]

yeah i noticed, but it doesnt work, it give me the results for the current month and not for the cumulative

[marcus_sommer]

Instead of YearMonth you need to apply the used period-fields - in this case it looked at least like Monthnum.

[aresb]

hi marcus

i came up with this formula and it's working 

aggr(RangeSum(Above(TOTAL sum({<YearMonth=,Date=,Year={"=$(=max(Year))"},[Month num.]={"<= $(=max([Month num.]))"}>}cod_connid_2_3_4_6_7_v), 0, RowNo())),Period,Country)

the last problem is that doesn't reset for every country 

any idea on how to resolve this ? 

[marcus_sommer]

The aggr() has a further parameter to sort the aggr-results - maybe an adjustment in this regard may be helpful.