Date comparison

[valpassos]

Hi all,

I have this formula giving me the variance between two years, making use of Flags as created in my master calendar:

sum({<CYTD={1}>} Sales)

/

(sum({<FPYTD={1}>} Sales)) - 1

YTD = Current Year-to-Date:

FPYTD: First prior Year-to-Date

And I have a QuarterYear field declared in this way:

dual('Q' & ceil(month(D)/3) & '-' & Year(D),ceil(month(D)/3)+Year(D)*10)

This gives me Q1-2017,Q2-2018,...

PROBLEM: when I filter by QuarterYear, my % variance collapses. I no longer have the denominator, always rendering zero.

Do you know why this is happening?

Thanks,

Lisa

[valpassos]

Thanks raman.rastogi‌ and dilipranjith‌! That was very useful

Lisa