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

    Errors summarizing data based on dimension


      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"






      My Measure

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



      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.