5 Replies Latest reply on Nov 2, 2018 8:01 AM by Cédric Tran

    Dividing a LOD by a LOD gives wrong answer

    Elizabeth Perry

      Hi, I've created LOD calculations to show sales and commercial margin as my dataset has overall totals showing on each row. The LODs work correctly per measure but as soon as I try to find the percentage of one from the other i.e. I want to divide LOD_CM by LOD_SALES to see what our margin was a % of sales I get what looks like a random answer. See below LODSales is correct as is LODCM but LODCM%2018 which is LODCM / LODSales returns 194.6% rather than 29.7%, is it possible to calculate %s using LODs?