Forum Discussion

_Janwi31's avatar
_Janwi31
Frequent Visitor
3 years ago
Solved

Year Column as Fiscal Year

I want these values๐Ÿ‘† to be written as FY 23-24.

Please help me with this.

  • Hi 

     

    as it's a numeric field that won't be possible. You can either change the field type and replace the values or add a new column with the below:  if [Column Name] = 2023 then "FY 23 - 24" else [Column Name]

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos ๐Ÿ‘

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar

    Hi 

     

    as it's a numeric field that won't be possible. You can either change the field type and replace the values or add a new column with the below:  if [Column Name] = 2023 then "FY 23 - 24" else [Column Name]

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos ๐Ÿ‘