Skip to Content
author's profile photo Former Member
Former Member

Issue with currency conversion

Hi Experts

I am facing a issue while calculating the currency conversion. We r having a report which display the amount for the individual months as well as YTD values when v r doing the currency conversion for the individual months v r getting the right values but not the same with YTD.

Suppose we r having 100 records for jan and dollar rate is 41, 150 records for feb with dollar rate 42,

And March we are having 200 records with dollar rate 44, if I had taken the values on an average like 41,42,44 divided by 3 and this value is multiplying with the number of records we are not getting the Accurate value.

Pls let me know what I have to do to achieve the same.

Thanks in Advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 06:46 AM


    To achieve this we need to incorporate this in the data-modeling stage only.... Since your dataprovider will have Summary level data the averaging might not work. You need to convert it for each and every record.

    So better incorporate this in the modeling stage itself.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.