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

Dividing a LOD by a LOD gives wrong answer

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?

• 1. Re: Dividing a LOD by a LOD gives wrong answer

For better assistance, can you share sample workbook or data.

• 2. Re: Dividing a LOD by a LOD gives wrong answer

Hi Venkatatram, I can't share the data unfortunately. I just wondered whether it's possible to divide LODs by each other? If they appear correct as individual calculations why would one divided by the other produce something different?

• 3. Re: Dividing a LOD by a LOD gives wrong answer

Hi,

Try to Sum (LOD1) / Sum(LOD2) in your calculation.

Cedric

1 of 1 people found this helpful
• 4. Re: Dividing a LOD by a LOD gives wrong answer

Fantastic, thanks so much Cedric!

• 5. Re: Dividing a LOD by a LOD gives wrong answer

You're welcome ;-)