2 Replies Latest reply on Mar 31, 2016 9:33 AM by BI BLZ

    Alternative method to calculate LOD with different data sources

    BI BLZ

      Hi,

       

      I have three different data sources: one for net revenue and sales on goods level, one for COGS with invoices and one for average monthly cost for each product code. All of them are connected ( blended) by the product code. When I calculate the costs for each product code the results are ok, but when I try to get the total cost of the day(or other interval of time), it is ruturnig a distorced value.

      I know that I can not use LOD with different data sources. So, what can I do to solve this problem?

       

       

      Regards.