LAG function - date format
Hello Anaplan Community,
I've encountered an error message that's been causing some confusion for me.
I'm sure I'm missing something crucial with the LAG function, and I'd greatly appreciate your assistance in resolving this issue.
As far as I understand, the LAG function in Anaplan is used to return values from a prior period. The value to offset can be of any format. My specific aim is to use this function to retrieve a date from the past, and in our model, time scale is set to Day. I've attached a screenshot of the simplified model for reference.
The expression I intended to use in the LAG function is as follows: LAG(Date to Replace with, Offset Amount, Blank).
However, when I attempt to implement this expression, I'm encountering an error message (see bellow image).
Could someone kindly help me understand what might be wrong with my formula and provide guidance on how to correct it?
I want to thank you in advance for your assistance in resolving this issue.
Looking forward to your guidance.