month Calculation

[Neffri]

Hi,

Do you know how to create calculation which will be giving the Corresponding column?

Thank you!

[Emil_Kos]

Hi,

There is any rule how the second column was created?

I don't see any pattern in those columns. 

[Neffri]

It takes the last day of the last month of the quarter and transfer the value for the next 3 months.

[Emil_Kos · Accepted solution]

Hi,

I hope it will be helpful. 

[Neffri]

I found one issue with this solution, for example: current 2020-07-31 will 2020-06-31 which isn't correct  because should be 2020-06-30.

[Emil_Kos]

Hi @Neffri,

I will take a look for you.

[Emil_Kos · Accepted solution]

Hi @Neffri,

Thank you for pointing this out. This should work.