I have a G/L table with values by FY, Month, Locations, GL accounts and Amounts. My “Total_Amount” calc works perfectly (, but when I use either the “SameDateLastYear” function or the “DateAdd” function, the “Total_Amount_LY” returns the same value as “Total_Amount”. I’ve literally copied formulas from the learning (several varieties) and still no luck. At my wit’s end…any suggestions?
Table looks like this:
FY Month Location GLAccount Amount
2020 Jan 1 1000000 400
2020 Jan 1 2000000 240
2020 Jan 1 3000000 308
etc for multiple values in each column.
My result on the canvas looks like:
FY Total_Amount Total_Amount_LY
2020 124,000.00 124,000.00
2019 119,500.00 119,500.00
2018 121,760.00 121,760.00
etc
I’m using the same Date table provided by Sam in the learning…linking the days to the months in the G/L table.
Any ideas?
Thanks in advance
Eric