YTD with only month and year

[dries_clairhout]

Good day,

A client of mine wants a YTD button,

problem is, for this financial report I made, it is based on a month and a year only.

There is no Datefield present in the database.

Anyway to put in a YTD button? actually a Year To Month button?

Thanks in advance!

[Sameer9585 · Accepted solution]

Do you know how to create a button?

If yes,Then create it and use the formula as

Sum({<Year=,Month={"$(= '>=' & YearStart(AddMonths(Max(Month),-11)) & '<=' & Max(Month)"}>})

[dries_clairhout]

Hello,

Thanks for the formula.

Button creation I don't know,

I use the climber extension to make years abd months selectable.

But when I put the formula in the field value, I get nothing....

Any suggestions?

thanks

[Sameer9585]

sorry I don't about buttons that why I asked ?But the formula works fine.