3 Replies Latest reply on Jul 18, 2018 6:20 PM by Zhouyi Zhang

# LOD returns all zeros

i am struggling trying to write this LOD.

The LOD is equivalent to a table calculation as a % of Total, with 'calculate on' SegmentLabel1 (and filtering away "Overall")

of to simplify, divide each SegmentLabel1  by "Overall"  or 9,428,025 / 265,098,436.

_the problem is Overall is an item in this Dimension, so if you just sum the Dimension, it doubles the real value.

_ the view will not look like this, it will be filtered to only show top 3 values

• ###### 1. Re: help with LOD

Hi, Jon

Can you provide a sample workbook? and what should be the expected result?

ZZ

• ###### 2. Re: help with LOD

hi, here is a packaged workbook, , let me know if you have question, i added some extra context to my original message

• ###### 3. Re: help with LOD

Hi, Jon

If I understand correctly, you solution should work even though it shows 0 and 1, but if you do a format as shown below, it gives you the percentage

Is that something you expected?

ZZ

1 of 1 people found this helpful