11 Replies Latest reply: May 25, 2017 1:11 AM by P M RSS

    Condition check

    Agrim Sharma

      Hi All,

      i have made this formula to achive

       

      <(less than 0.75) over budget

      between(o.75-0.85)within budget

      &

      >(Greater than 0.85)-underbudget

      PLEASE CHECK IS THIS RIGHT CONDITION??

       

       

      LOAD "Project

      CPI",

      IF("Project

      CPI"<0.75, 'OverBudget', IF("Project

      CPI" <=0.75,  'Within Budget','Under Budget' )) as CostClassification