4 Replies Latest reply: Nov 22, 2016 1:05 AM by naveen kumar RSS

    how to write expression

    naveen kumar

      Hello Everyone,

      can anyone help me in correcting this expression plz ,i have no clue where it is going wrong

       

      when i use the Ceil expression(if(ceil(Day/7)>4,4,ceil(Day/7)) as Week) i am getting the values like

      1

      2

      3

      4

      but what i am looking  is

      Week1

      Week2

      Week3

      Week4

      that is the reason why i am  trying  this expression

      Expression:

       

      If(Day<=7, Dual('Week1', 1),

          If(Day<=14, Dual('Week2', 2),

          If(Day<=21, Dual('Week3', 3),

          If(Day<=31, Dual('Week4', 4))))) as Week

      but something is missing from this expression , can suggestion plz

       

       

      Untitled.pngUntitled1.png