Why is full year showing instead of date selected?

[dwighttrumbower]

I have this formula SUM({<Year={'$(vPriorYear)'},Date={'<=$(vPriorYearDate)'}, Month=, Week=>}DealerCostUSD)

VPriorYear is 2024 and vPriorYearDate = 2024-04-11

If I filter on Year 2025, it sums all of 2024 instead of <= 2024-04-11.

Thanks

[SRA · Accepted solution]

Hi,

Can you try with :

SUM({<Year={'$(vPriorYear)'},Date={"<=$(vPriorYearDate)"}, Month=, Week=>}DealerCostUSD)

Regards,

[dwighttrumbower]

I have tried that to with the same results.

[dwighttrumbower]

There where a few issues, but solved thanks to SRA.