Hello @rit372002,
Based on the scenario that you had specified in the original post alongwith the screenshot, solution was provided in accordance with that wherein you wanted to multiply the single conversion rate with the average figures.
For the new scenario’s, as per the forum guidelines, please create a separate thread by providing the proper description of the query.
And as far as, totalling is concerned, below is the link of the thread provided for the reference which addresses the issue pertaining to the topic - “Fix Incorrect Totals”.
Note: In your revised query, you haven’t specified which all currencies are considered for evaluation of results. Are you considering multiple latest currencies or exchange rates at a given time. Why? Please provide proper description in your new thread so that members of the forum can assist you in a better and efficient manner.
Thanks and Warm Regards,
Harsh