YoY YTD comparison

sharu055 — Thu, 20 Oct 2022 14:55:17 GMT

Hi,

I am having two fields, Date & Money. having two years of data (2021,2022)

i want to make sum of Money for present year YTD in one column and Sum of Previous year same YTD as present year.

How to write he expression.. please help

Re: YoY YTD comparison

BrunPierre — Thu, 20 Oct 2022 21:32:41 GMT

Sum({$<Date={"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"},Year,Quarter,Month,Week>}Money) // Present Year YTD

Sum({$<Date={">=$(=YearStart(Max(Date), -1))<=$(=AddYears(Max(Date), -1))"},Year,Quarter,Month,Week>}Money) //Previous Year same period

topic Re: YoY YTD comparison in App Development

YoY YTD comparison

Re: YoY YTD comparison