1 Reply Latest reply: Dec 18, 2012 11:50 AM by Vlad Gutkovsky RSS

    Add calculated dimension

      Hello;

       

      I am trying to add a calculated dimension to a chart and the legend returns an error.

       

      The statement used works well in an expression but not in the dimension side.

       

      Any idea why?

       

      This is the statement in question.

       

      =if(

      (If(ActivityType='INEN'OR ActivityType='ISSS'OR ActivityType='IDOA',1,0))

      +

      (if(((SUM(_Hours_worked))/[Target Inst Hours])>0 and ((SUM(_Hours_worked))/[Target Inst Hours])<0.3 or ((SUM(_Hours_worked))/[Target Inst Hours])>1.5,1,0))>0,'Problem','No Problem')


      Many thanks in advance for your answer.

       

      Kristel.