Inflation Rates Adjusting Year of Payout to Loss Year accounting for inflation

[Anonymous]

Hello, 

I have been tasked out with creating a dashboard that shows the payout spend compared to the loss year spend, accounting for inflation (year over year, various years).   Basically, I want to see if im spending more money today than the loss date.  Data and rates below. 

Payout Date	Loss Date (Year)	Payout Year	Region	Total		Inflation Rate	Year
1-Jan-24	2023	2024	A	-1547.72		2.10%	2017
1-Jan-24	2023	2024	B	4040.44		2.40%	2018
1-Jan-24	2023	2024	C	104.2		1.80%	2019
1-Jan-24	2023	2024	A	12231		1.20%	2020
1-Jan-24	2019	2024	B	2561.4		4.70%	2021
1-Jan-24	2023	2024	A	27135.18		8.00%	2022
1-Jan-24	2022	2024	B	-12285.27		4.10%	2023
1-Jan-24	2023	2024	A	315123		0.00%	2024
1-Jan-24	2014	2024	B	407
1-Jan-24	2017	2024	A	200206.6
1-Feb-24	2023	2024	B	749.47
1-Feb-24	2023	2024	C	22837.77
1-Feb-24	2017	2024	A	7
1-Feb-24	2023	2024	B	15403.35
1-Feb-24	2024	2024	C	165
1-Feb-24	2023	2024	A	406.98
1-Feb-24	2022	2024	B	31.35
1-Feb-24	2016	2024	C	1986
1-Feb-24	2023	2024	A	7497.12
1-Feb-24	2023	2024	B	12342.62
1-Feb-24	2015	2024	C	4964.75
1-Apr-23	2014	2023	A	3161.5
1-Apr-23	2017	2023	B	6064.65
1-Apr-23	2019	2023	C	492.27
1-Apr-23	2017	2023	C	2628
1-Apr-23	2023	2023	C	72
1-Apr-23	2023	2023	A	4952.46
1-Apr-23	2015	2023	B	200.48
1-May-23	2023	2023	C	68621.64

[Anonymous]

Hi, @Anonymous 

Not being very good at economics and failing to understand what you ultimately want to achieve, you can elaborate on the mathematical logic of the result you want to achieve to help solve your problem faster.

Best Regards,
Yang
Community Support Team