4 Replies Latest reply on Aug 26, 2016 10:33 AM by John Burton

# LOD Calculation giving and unexpected result

Hi,

I'm using a LOD calculation to test which of two numbers is greater but in some cases I'm getting an incorrect result.

Here is the LOD calculation:

I'm comparing the amount in a base year to the amount in a comparison year.  I want to get a total count across all municipalities of cases where the number is higher in the comparison year.  I know the total count should be 186 but this is not the result I'm getting.

Here is an example of an incorrect result:

The amount has decreased between years but the calculation indicates and increase.

If you know what I'm doing wrong could you please let me know

Here are the other calculations used in the above table:

• ###### 1. Re: LOD Calculation giving and unexpected result

This is hard to answer without seeing the actual workbook. Can you attach it to your post?

If that is not an option I have a few questions:

1. Is [Count - Increasers] a measure? If so, how is it being aggregated?
2. Is [Amount - Change Base to Comparison] being aggregated in your table? If so, using what function?
3. What is your formula for [Amount - Change Base to Comparison]?
1 of 1 people found this helpful
• ###### 2. Re: LOD Calculation giving and unexpected result

Just a quick question. Are you using any quick filters? Those will impact your calculated fields but "fixed" happens before them.

I dont really understand what you're trying to do and why a lod is needed but that could be an easy fix.

• ###### 3. Re: LOD Calculation giving and unexpected result

I am using a quick filter and that is what's creating the problem.  Thanks for identifying where I was going wrong!

The reason I'm using a lod calculation is because I want a text box on a dashboard that says "Between 2014 and 2016 the amount increased in X municipalities".  For the X value I want to use sum(Count - Increasers).

Hopefully I can get everything to work now that I understand the order that filters are executed.

• ###### 4. Re: LOD Calculation giving and unexpected result

By the way, I found what helped me get the result I want is to add a context filter as it's applied before the LOD.

Thanks again.