4 Replies Latest reply on Oct 11, 2016 8:01 AM by Shinichiro Murakami

    Parameters for blank columns

    William Hampton

      I have a situation where I have a sales metric for 2015 and want to use a parameter for my growth factor to predict 2016 sales.  I have a placeholder for 2016 in my raw data and want to figure out how I can create a calculation that will input my data into my dashboard.


      I have attached my workbook and a screenshot of my dataset layout.  My dataset layout looks like this:



      Ideally, I want worksheet to look like this using 10% as my sales growth from the parameter


      Calculated Field$1,000$1,100


      However, when I do this using a case statement, 2016 stays blank (putting year as my column)


      Any help would be appreciated.