Arithmetic operations for date column

Hi,

I have a monthly time series for price data in long format, that is one price per key per month in each row. Now I need to calculate the previous month column (current month -1). But I am not sure how to do it. Any help is appreciated. Thanks.

Best regards,
Siva

@Sivasanmugam

Maybe this thread The Best Way for the end of month - #2 by mlauber71 could help you to find a solution.

Hi,

What is the data type of the current month column? Can you upload a data sample?
If the current month is integer you can use “Math formula” node and do a subtraction.

Have you tried the Lag Column node (allows to shift one or more rows)

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.