Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
4 years ago
Solved

How to write expression for calculated column = if (columnvalue-1=0 then 12 else column value-1)

How to write expression for calculated column = if (columnvalue-1=0 then 12 else column value-1)

  • Hi Ramendra,

     

    You can try below code:-

    column = if (table[column]-1=0,12,table[column]-1)

    Thanks,

    Samarth

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion

    Hi Ramendra,

     

    You can try below code:-

    column = if (table[column]-1=0,12,table[column]-1)

    Thanks,

    Samarth