7 Replies Latest reply: Feb 16, 2012 7:10 AM by John O'Mahoney RSS

    Set analysis not retaining total

      Hi all

       

      I have a number of properties and can create a percentage of current selection / total properties

       

      =sum(PropertyIDCounter)/sum({1}PropertyIDCounter)

       

      I also have a bookmark that filters the total properties into a specific group and I want to work out the percentage based on this bookmark

       

      =sum(PropertyIDCounter)/sum({$*BM05}PropertyIDCounter)

       

      However, when I apply a filter to the data the sum({$*BM05}PropertyIDCounter) also reduces

       

       

      How do I apply the {1} effect in the first expression that retains the full count of the bookmark regardless of subsequent applied filters

       

      Thanks in advance

       

      John