5 Replies Latest reply: Mar 15, 2013 7:14 AM by minimuke RSS

    if...elseif... in calculated dimensions

      I need to reflect in a column graph (stacked) how many helpdesk jobs are completed on time, completed late and still outstanding. So far through a calculated dimension I've managed to show number of jobs completed late and on time by using the following if statement:

       

      =if (FINISH_DATE >> DUE_DATE, 'Late','On time')

       

      When I used if...elseif...else...end if I couldn't make it work, it tells me I've got garbage expression. What can I do if I have more than two options to display?

       

      Many thanks in advance