3 Replies Latest reply: Mar 27, 2015 1:37 PM by Sunny Talwar RSS

    Help with expression

    Matt Maino

      I need help with an expression that I am using in a straight table to calculate a weighted average.

       

      This is the expression:

      =(Field_1*Field_2) /

      (sum(total if((STATUS <> 'X' and STATUS <> 'C') and (DESC = 1 or DESC = 3 or DESC = 7), Field_2)))

       

      I need the denominator to remain the same regardless of the current selection, but it is changing when I make a selection. How do I prevent this? I should note that putting a {1} won't work since I am looking at data based on the date so I need to leave that filter in place.

       

      Thank you!