Will lag function works for Boolean Formatted Lineitem?

PujithaB

Hello Community

As Anapedia says, lag function can take Boolean formatted lineitem
I have a scenario as below
I have a module dimensioned by Numbered list and Time scale
And I have 3 lineitems as below
1. Lag value - — boolean
2. Lag offset Amount ——Number
3. Output lag ——Boolean
Formula for lineitem Output lag = lag(lag value, lag offset Amount , false)
This formula has thrown me an error.

Any inputs on this will be helpful.

Thanks
pujitha

NikhilGuntuku1

@PujithaB The Lag function as of now works best on Number formatted line items to Lag used on the Offset value, but for Boolean formatted line Lag will work with Constant offset

Example: Output Lag = Lag (Lag Value, 2, FALSE)

For the scenario you used above the error Anaplan shows up is that all the arguments for Lag should be Number formatted.

Instead of Lag, you can use Offset as an alternative, which will work with the scenario you used for Lag

Example: Output Offset = Offset(Lag Value, Lag Offset Amount, FALSE)