4 Replies Latest reply on Sep 21, 2016 3:53 PM by Shraddha Sonawane

    Excluding a filter during calculation

    Shraddha Sonawane

      Hi,

       

      I am calculating a ratio in which my numerator uses a different filter than the denominator. I am trying to do this using the EXCLUDE LOD expression but it doesn't work as expected.

      It includes the excluded filters too. The filter I am using is a date filter on both the numerator as well as the denominator but the filter values differ for the two. There is also another filter Count which I use only for the numerator.

       

      The expected value of ratio in the sheet is ~12%. I have tried several things now but it doesn't seem to work.

       

      Attaching the worksheet. Please help!

       

      Thanks,

      Shraddha