1 2 Previous Next 18 Replies Latest reply on Nov 20, 2017 12:18 PM by Diogo Braga

    EXCLUDE one dimension value from LOD FIXED Calc

    Diogo Braga

      I am hoping this can be solved without having to share the workbook.

       

      Here is the challenge: I have the following working LOD calc, but it the calc shouldn't apply if Metric = 'FOODSERVICE.'

       

      Any ideas? Thank you!

      2017-11-20_1024.png

       

      {FIXED [School Code], [Metric]: if [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Red' and

      [CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Red' and SUM([17-18 Fall Agree & Strongly Agree]) <.6

      or

      SUM([17-18 Fall Disagree & Strongly Disagree]) > 0.1 then '⚑'

       

      elseif [CF 17-18 16-17 Fall Strongly Agree Diff] = 'Green' and

      [CF 17-18 Fall Strongly Agree Below CSUSA Avg] = 'Green' and SUM([17-18 Fall Agree & Strongly Agree]) >=.9

      or

      SUM([17-18 Fall Strongly Agree]) > 0.6 and SUM([17-18 Fall Disagree & Strongly Disagree]) <=.05 then ' '

       

      else ' '

      end}

        1 2 Previous Next