9 Replies Latest reply on Jun 26, 2018 7:40 PM by Deepak Rai

    Calculated field that references multiple fields

    Jon Boschee

      Hi everyone,

       

      I'm trying to create something where I can reference two different years.  My end goal is to be able to have two filters with one being for year of gross sales and the other being the year of exchange rate. 

       

      2018 gross sales * 2017 exchange rate

      or

      2017 gross sales * 2018 exchange rate

       

      I want the ability to change the year for each one.

       

      Any ideas would be greatly appreciated!

       

      Thanks!