Forum Discussion

j0woods's avatar
j0woods
New Member
5 years ago

Inflation Calculation at Sub Category Level

I am needing to specify the "level of calculation" for an inflation formula in my dataset, and I have not found a good way to do so yet. See the tables below for a simplified model/calculation. In th...
littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
5 years ago

First, create a hierarchy of Category/Subcategory.

Then in the measure to define inflation, use ISINSCOPE() to determine which level of the hierarchy is being calculated.  Note: check hierarchies from lowest level first to highest level last.

Can you provide some raw data to work with?