To Have previous Year Amount

Question & Answer
,
1

Hi,

I am facing an issue with the MOM % calculation for January (1) in the dashboard. The correct formula for January should be:

(January Current Year / December Previous Year) - 1

For example, in my case, the calculation should be:

(1,642,920.51 / 1,820,726.71) - 1 = -9.77%.

The rest of the months seem to be calculated correctly, but January is not. Also, note that the numbers 1, 2, 3, etc. are used as month identifiers, so Jan 2022, Jan 2023, and Jan 2024 all correspond to 1 (representing the last two years, last year, and the current year).

Current Year is calculated by help of calculated field where date >= 1 Jan 2024 and date <= 31 Dec 2024
Previous Year date >= 1 Jan 2023 and date <= 31 Dec 2023

Could you please help me resolve this?

image
image795×365 40.9 KB

2

Hello Nirmal,

May be this old post may help to get some direction.

see - Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hope this helps.

Cheers,
Deep