Accumulation

[#1]

Hi Guys,

I have one doubt could you please help me in this.

I have data like below

Raw data sheet and Exchange sheet. attached here.

Could you please let me know how can i achieve this requirement.

Find out the Start date & End Date in the fact table (Raw Data) and identify the latest Exchange Rates for the currency only get one more additional column as Exchjnage Rate in the output file

[robert_mika]

Is this just a sample or full data set?

What result do you expect for the first line in Raw Data(which currency)?

At the moment you have one exchange rate for each currency.

[#3]

i guess, you can load your data using SORT BY in the end of your load

and than create a variable and use peak() where you input your table, your column and tell the function to find the last row (-1)