Why use this feature
When working with money-related data, adjusting values for inflation lets you compare numbers across different decades on the same scale. This ensures consistency when analyzing income, spending, or cost-related variables over time.
How to Adjust $ Values
- Create your report with tables that contain dollar values.
- The inflation adjustment option will appear automatically if $ variables are included.
- The inflation adjustment option will appear automatically if $ variables are included.
- In the Modify report panel, find Adjust $ values for inflation.
- Open the dropdown menu and select the year you want to use as the adjustment base.
- The table updates automatically, redistributing values according to the selected year.
How It Works
- Bracketed variables (e.g., household income ranges) keep the same brackets, but the population values inside them are redistributed to match the inflation adjustment.
- This makes brackets directly comparable across years without changing the categories.
Where You Can Use It
Adjusted $ values will be applied in all three views:
- Report tab
- Excel tab
- Data Download tab