-
Re: LAG function - date format
@MoraruD You were almost there…Instead of using the cumulate line item as the second parameter in the LAG function, replace it with a 1 or a 2, basically a constant. That will get it working, but the…1 -
Re: Year to go calculation
@klameer Try unchecking the Switch over boolean for the Amount YTD and Amount YTG as well as Full Year.1 -
Re: User List in PROD and Sandbox models
@HarunT Correct, when a user is created, it is actually provisioned to the workspace and then the User Role grants access to the model. Same thing when deleting users, they are removed from the works…1 -
Re: User List in PROD and Sandbox models
@HarunT Creating a new workspace is a fairly easy thing to do, your Anaplan BP can help you out with that. All you need to do is figure out what you want to name, I would recommend something with San…1 -
Re: How to convert an annual amount to a monthly amount
@Vamsi_Kaki Yes, the lookup will work, but Yearvalue() will perform better because the lookup is already built into the function.2

