2 Replies Latest reply on Apr 13, 2016 5:15 AM by Joe Baker

    Aggregation based on row level filter?

    Joe Baker

      Hi,

       

      Is there a way to write a Calculated Field that only calculates over rows that meet a certain condition?

       

      I want to create a Weighted Average (Factory) calculation for all rows where the Factory Include column = "include".  I would also like to create another Weighted Average (Plant) calculation for all rows where the Plant Include column = "include".

       

       

       

      Ideally I would like my Wght Quantity (Factory) measure to only calculate when the row level field of Factory Include = "include"

       

      Any ideas? I'm using 9.2