Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I've a table :
DatePrest; Group field; ... some fields...; Revenue
I'd like to show an Year To Date table like this:
Group Field; Current Year Revenue; Previous Year Revenue
Where i need to filter dates for:
Current year= 2023-01-01 to 2023-05-21
Previous year= 2022-01-01 to 2022-05-21
How to write correct set analysis ?
Thanks
Hi, the expressions could be:
- Sum({<DatePrest={">=$(=YearStart(Max(DatePrest)))<=$(=Max(DatePrest))"}>} Revenue)
- Sum({<DatePrest={">=$(=YearStart(Max(DatePrest),-1))<=$(=AddYears(Max(DatePrest),-1))"}>} Revenue)
Maybe you need to add a Date() function to enclose the expressions inside $()
Hi, the expressions could be:
- Sum({<DatePrest={">=$(=YearStart(Max(DatePrest)))<=$(=Max(DatePrest))"}>} Revenue)
- Sum({<DatePrest={">=$(=YearStart(Max(DatePrest),-1))<=$(=AddYears(Max(DatePrest),-1))"}>} Revenue)
Maybe you need to add a Date() function to enclose the expressions inside $()