1 Reply Latest reply on Jul 5, 2017 1:15 PM by Mihai Constantinescu

    LOD and time

    Alex Martino

      Would something like this ignore time?

       

      I have two channels, and I want to get the % of each state as a % of the channel, so I'm using the number below as the denominator. I want the states (which are filtered) to show up as a percentage of ALL the states in the channel even if they aren't showing. The number that I'm getting is WAY off so maybe it's ignoring date specifications?

       

       

      {Fixed[Channel]: SUM([Total Adjusted Gross Amount])}

        • 1. Re: LOD and time
          Mihai Constantinescu

          {Fixed[Channel]: SUM([Total Adjusted Gross Amount])} / {SUM([Total Adjusted Gross Amount])} is this how you do the %

          First bit will do sum per channel (across all time if no filter) and second bit sum of all states, rows of channels ...

          Is this what you wanted? If not, can you share a workbook?

          1 of 1 people found this helpful