5 Replies Latest reply: May 5, 2017 5:31 AM by Pradip Sen RSS

    range condition

    Agrim Sharma

      hi,

      i want get the values whose are between 0.9-1 as "Within Budget" eg. 0.91, 0.92, 0.93...0.99, 1

       

      >=0.9 and <=1

      i have this

       

      [Data3]:

      LOAD "Project

      CPI",

              

                IF("Project

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

      CPI"=0.9, 'Within Budget',IF("Project

      CPI">0.9, 'Under Budget'

                 ))) as CostClassification

      FROM [lib://vvv/vvvv.xlsx]

      (ooxml, embedded labels, table is Projects);