3 Replies Latest reply: Nov 30, 2015 5:53 PM by Massimo Grossi RSS

    Data Island calculation

    Mark Rudolphi

      I'm looking for the appropriate formula to include in a chart expression. 

       

      Here is an example set of data.  I have 3 data islands.

       

      Data Island 1

      Parts     Price

      PartA     10

      PartB     20    

      PartC     30

       

      Data Island 2

      Parts     Currency

      PartA     USD

      PartB     USD

      PartC     EURO

       

      Data Island 3

      Currency     Rate

      EURO      1.09

       

      Island 2 identifies the currency in which Island 1's prices are entered.  I would like to create a table chart that lists prices by part all in USD.  Therefore, if the parts currency is already USD then just show the price but if the Currency is Euro then it needs to take the price and multiply by the rate.  The chart table should result in:

       

      Parts     Price

      PartA     10

      PartB     20    

      PartC     32.70