5 Replies Latest reply on Jun 27, 2018 10:58 PM by Shinichiro Murakami

    Issue with join impacting Sales

    Jon Boschee

      Hi everyone,

       

      I'm running into an issue where I currently have 3 join clauses.  This however causes my sales conversion into USD to be incorrect since it omits certain exchange rates.

       

      If I remove the year join clause, all my exchange rates are present but then my sales increase by a factor of 4.

       

      Anyone run into something similar?

       

      Thanks!