5 Replies Latest reply: Feb 28, 2010 4:02 PM by John De Loach RSS

    Extract value out of a crosstable in the script

       

      Dear Experts,

      my English is still not better but I try to explain what I'm working for hours on.

      I load rate table

      TableRate:

      CurrencyCode | Year08 | Year09 | Year10 |

      EUR | 1,1 | 1,1 | 1,2 |

      USD | 0,9 | 1,0 | 1,1 |

      as a crosstable.

      And I got a data table like this:

      TableData:

      …|Currency | Date | Value | …

      …|EUR | 1.2.09 | 100,00 | …

      ….

      Now I need to calculate in the script by the different rates the Value in the local currency like this

      Value * ….(Currency, YEAR(Date), TableRate) >> 100 * 1,1 = 110

      So I need a command to select a value out of a Crosstable by given the x and y coordinates

      If somebody have a idea to solve my problem I would be happy if he/she shares with me.

      THANKS for thinking about!

      Regards

      John