Hi friends,
It's been to long since I used time in SET, try to avoid that, but now I have to build my time limits in a chart.
I need to see last period - always previous month, this year and for last year. Trying this but can't seem to get it to work:
Sum({$<Year = {$(=Year(Today()))}, Month = {$(=Month(Today())-1)},Year=, Month=>} Amount))
and
Sum({$<Year = {$(=Year(Today())-1)}, Month = {$(=Month(Today())-1)},Year=, Month=>} Amount))
I also need the acumulated amount from yearstart to monthend previous month...
Best regards
Torbjörn Ungvall (@Ungvall)
Senior Business Discovery Manager
Advectas AB
