How The Calculator Works

properties

• Select base year: relation to dataset

• Select base CPI: rollup to Select base year

  • In this property, select either specific month in year or year average.

• Select most recent year: relation to dataset

• Select recent CPI: rollup to Select most recent year

  • In this property, select either specific month in year or year average.

• Inflation Rate Discrepancy: formula

  • format("about ") + format(round(100 * (toNumber(prop("Select recent CPI")) - toNumber(prop("Select base CPI"))) / toNumber(prop("Select base CPI")) * 100) / 100) + "%"

  • Syntax result: about _%

DataSet Also Included

COPY TEMPLATE