Forum Discussion

aschlafer's avatar
aschlafer
Regular Visitor
7 years ago
Solved

Converting Fiscal Year Text to Number

Hi all,    I'm running into some trouble because our database stores our fiscal year data in text format (i.e. FY16, FY17, etc.) and I need to create a calculated column to help me switch the text ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    Hi, In Query Editor..yo can

     

    1. Add a Column - And Extract - Text After Delimeter --FY This obtain 16 , 17 ,etc

     

    2. a new column =  2000+ ThePreviousColumnCreated,

     

    Regards

     

    Victor

Vvelarde's avatar
Vvelarde
Community Champion
7 years ago

Hi, In Query Editor..yo can

 

1. Add a Column - And Extract - Text After Delimeter --FY This obtain 16 , 17 ,etc

 

2. a new column =  2000+ ThePreviousColumnCreated,

 

Regards

 

Victor