KPI CY vs. PY

[jherrerae]

Hi all.

I'm trying to compare de number of POD's of any year vs. number of POD's of previous year.

But it doesn't work!!!

Any Year

=Count({$<Year={$(=Year(Fecha))}>}Viaje)

Previous Year:

=Count({$<Year={$(=(Year(Fecha)+1))}>}Viaje)

But the result is...

[sunny_talwar]

Previous year should be -1

=Count({$<Year={$(=(Year(Fecha)-1))}>}Viaje)

[jherrerae]

Not, because "Fecha" is the date of the POD.

Anywey, Is the same result

[sunny_talwar]

Not sure I understand?