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

    Add calculated dimension



      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(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.