5 Replies Latest reply on Aug 31, 2018 10:40 AM by Melissa Fanucci

    Calculated field needed to add price index adjustment to values

    Melissa Fanucci

      Hey all,

       

      I'm still new at figuring out my own calculated fields. In the attached workbook, I have values of exports and imports, but I want to adjust them to 2000 U.S. dollars based on the US Dept. of Labor Statistics import and export price indices.

       

      I've created a separate data source with the year and adjustment value. Now I need to come up with a calculated field to create a measure that isn't the "Total" but rather the "Adjusted Total." Can someone assist? Thank you so much!

       

      Melissa