3 Replies Latest reply: Feb 22, 2014 8:52 AM by art lan RSS

    calculate Price Index in script

      Hi everybody,


      In the attached QVW I have 3 variables: Country, Year and #Price.

      For each Country I want to calculate in the LOAD Script the Price index based on the first year of data. Each country has a different start year.


      The calculation must be something like this, per country: ('#Price concurrent year' / '#Price first year') * 100


      Can somebody help me to integrate this in the LOAD Script. I also attached the data source in excel.


      Your help is appreciated! Arthur