Previous Year data not showing up.

[dwighttrumbower]

I created a new app, but copied sql, mappings, date calendar and variables from an existing app that works.

Showing a simple table. This works on the existing app.

When I copy the table to the new app and use the same filter(Year=2025), the previous year sum data shows 0. 

On the existing table both 2024 and 2025 rows appear. In the new app only the 2025 rows show and not 2024.

New app/sheet

Grok had decent debug info and it was the same stuff I was using, but for some reason 2024 data is not showing. It is probably something simple, but I'm racking my brain right now.

Thanks for any help. 

[PrashantSangle]

with this 2 screenshot & limited info difficult to suggest solution. 

does both app have same script? any difference including variables? 

Also, looking at screenshot, I can say only thing is that in both you have selected wrong year. in 1st you select 2024 & in 2nd you select 2025.

Do you have 2024 data in your 2nd app?

It is better if you shared your app with us to debug it.

Regards,

Prashant Sangle

[dwighttrumbower]

Load scripts very similar. 
Variables are the exact same.
I have filtered both on 2025.  The one that shows 2024, data is filtered on 2025 and both years worth of data shows, because I'm doing previous year calculations.

[dwighttrumbower]

If I just calculate the whole previous year, I get 2024 data.

SUM({<Year={'$(vPriorYear)'}>} DealerCostUSD)

When I add the InvoiceDate, I get nothing.
SUM({<Year={'$(vPriorYear)'}, InvoiceDate={'<=$(vPriorYearDate)'}>} DealerCostUSD)

This evaluates to SUM({Year={'2024'},InvoiceDate={'<=2024-04-08'}>} DealerCostUSD)  Invoice date is in the same format, yyyy-mm-dd