3 Replies Latest reply on Jun 17, 2016 11:01 AM by Mahfooj Khan

    Errors summarizing data based on dimension

    mike.shapiro.0

      I'm trying to generate an average calculation, but only if the measure meets a dimension requirement.

       

      My Dimension

       

      IF [Marketing Strategy] = "AS IS" THEN "AS IS"

      ELSEIF  [Marketing Strategy] = "REPAIRED" THEN "AS REPAIRED"

      END

       

       

       

       

      My Measure

      IF ATTR([Strategy]) = "AS IS" THEN SUM([Sales Price])/SUM([EGV])

      END

       

      EDIT:  Looks like its the ATTR that is causing it to not sum.  Still not sure the best rout to have the measurement only look at cases that meet the marketing strategy above.