2 Replies Latest reply on Aug 6, 2016 10:47 AM by james.diaz

    currency conversion w data blending

    james.diaz

      i have 1 data source with transactions and dates, and secondary data source with conversion rates and dates. blending on currency AND date (month), i create a table calc like:

       

      sum([AMOUNT])*min([Sheet1 (conversion rates)].[USD per Unit])

       

      this does not return the correct converted totals over a 3 month period. it seems to take the lowest rate for the entire 3 months even though im blending on month and currency.

       

      when i create another view as a table, where the month and currency is included in the viz, it converts properly. but when i do it as a total for the quarter, it does not. any solution for this?