Anand Kote 2 Posted May 21, 2019 Share Posted May 21, 2019 I a trying to do something like below If Month = 0 then 01/01/2019 Or If Month =1 then 02/01/2019 and so on What is the best statement to do it in spotfire Link to comment Share on other sites More sharing options...
Richard Pobi Posted May 22, 2019 Share Posted May 22, 2019 Case When [Month] = 0 then '01/01/2019' When [Month] =1 then '02/01/2019' END Link to comment Share on other sites More sharing options...
Anand Kote 2 Posted May 22, 2019 Author Share Posted May 22, 2019 It will stop at 02/01/2019, however i am trying to do it for almost 900 months Link to comment Share on other sites More sharing options...
Richard Pobi Posted May 22, 2019 Share Posted May 22, 2019 You mean you have 900 different values for the Month column to write your logic Can you provide enough data to help us understand what you working with Link to comment Share on other sites More sharing options...
Anand Kote 2 Posted May 22, 2019 Author Share Posted May 22, 2019 Here is the data i am trying to add calculated column next to Month0 column starting from Month0=0 then 01/01/2019 , Month0=1 then 02/01/2019 and so on till 900 months Link to comment Share on other sites More sharing options...
Anand Kote 2 Posted May 22, 2019 Author Share Posted May 22, 2019 Yes, basically i am trying to calulate XIRR and in order to do so i need the date column. I am trying to find a solution to calculate XIRR and not the IRR Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now