Year on Year variance SSRS Expression

Question

Hi

I have an SSRS report with Start and End Date Parameters and I'm struggling to get the variance to work, I want to display current year selection spend with the var vs previous period per month in a matrix.

Thus I'm only selecting 2023 data but need the variance to 2022 same period ?

Example:

Month Spend Var %(To 2022 same month per row)

Jan23 R 1253 15%

Feb23 R 1585 5%

Mar23 R 2323 10%

Current Expression: (Just showing 100% for all)

=(SUM(IIF(Fields!Invoice_Year.Value=CStr(Year(NOW)),1,0)*Fields!TotalSales.Value)-

SUM(IIF(Fields!Invoice_Year.Value=CStr(Year(NOW)-1),1,0)*Fields!TotalSales.Value))

/SUM(IIF(Fields!Invoice_Year.Value=CStr(Year(NOW)),1,0)*Fields!TotalSales.Value)

Answer 1

Hi @Nadia Le Roux

I'm not particularly clear about your report design. Can you show it a little bit? This helps me test better for you. Please be careful to hide information that you think is more private.

Best regards,

Aniya