Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
2 years ago
Solved

If Statement

Hi, can someone please help with the correct syntax below please?   I am trying to categorise the expected application end date by adding on 2.6 years to applicants from their app_in date.    If ...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello M_SBS_6 ,

     

    you can acheive what you want in the following measure

    App_end = if(app[age group] = "18-25", date(year(app[app_in])+2,

month(app[app_in])+5, day(app[app_in])))

     

     

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

You need a calculated column : 

App_end = 
IF(
    app[age group] = "18-25",
    EDATE(
        app[app_in],
        2 * 12 + 7 // here you add 2 years and 7 months to app_in date
    ),
    app[app_in] // here your default case if age group is not "18-25"
)