3 Replies Latest reply: May 7, 2015 10:04 AM by Sunny Talwar RSS

    Help with set analysis

    Matt Maino

      I am trying to compute a sum to put in the denominator of a chart expression. This is what it looks like:

       

      (sum(total if((STATUS <> 'X' and STATUS <> 'C') and (TYPE = 'COMM MTGE' or TYPE = 'CONST' or TYPE = 'CONST/PERM'), BALANCE)))

       

      The problem that I am having is that I do not want this number to change if I make any selections on the document except for date selection. Is there a way to replicate this denominator expression but in a way that prevents it from being narrowed down by the current selections of the document? Kind of like a static number that only changes based on the date that I have selected.

       

      Thank you!