Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create Custom Column with multiple IF functions

Hi,   I have a table 'PlanYear' that I need to add a new column to.  I need this column to return "Current" if the [PlanYear] column is equal to 2021.  I also need this column to return "Prior" if ...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago

    Anonymous  change it to

    if (year(today())-1=[planyear],"prior"
smpa01's avatar
smpa01
Community Champion
5 years ago

Anonymousplease change the formatting of Plan Year column to Integer, it is currently formatted as text

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    While that fixed the #ERROR...my 2020 row is returning "Historical" instead of "Prior".  How should I go about resolving that?

     

    • smpa01's avatar
      smpa01
      Community Champion
      5 years ago

      Anonymous  change it to

      if (year(today())-1=[planyear],"prior"