3 Replies Latest reply on Sep 30, 2013 11:43 AM by Pedro Machado

    Creating custom reference line

    Kennen Gross

      I am trying to set up a custom reference line for the following project: Workbook: CustomReferenceLine

       

      I have custom values for each variable being shown, so I would like the reference line to differ for each.  Here is the formula that I have been trying but I know there is something missing.

       

      WHEN [% Advanced & Proficient ( Math 3rd grade)] THEN 82

      WHEN [% Advanced & Proficient ( Math 4th grade)] THEN 84

      WHEN [% Advanced & Proficient ( Math 5th grade)] THEN 74

      WHEN [% Advanced & Proficient ( Math 6th grade)] THEN 77

      WHEN [% Advanced & Proficient ( Math 7th grade)] THEN 78

      WHEN [% Advanced & Proficient ( Math 8th grade)] THEN 75

      WHEN [% Advanced & Proficient ( Math 11th grade)] THEN 59 END

       

      Any help would be greatly appreciated!  Thanks!