Calculated Column

[Anand Kote 2]

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

[Richard Pobi]

Case

When [Month] = 0 then '01/01/2019'

When [Month] =1 then '02/01/2019'

END

[Anand Kote 2]

It will stop at 02/01/2019, however i am trying to do it for almost 900 months

 

 

[Richard Pobi]

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

[Anand Kote 2]

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

[Anand Kote 2]

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