Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.
by utilizing the Functions MONTH() and YEAR() you can derive the number of months between 2 date formatted line items with this formula: IF ISBLANK(start date) THEN 0 ELSE IF ISBLANK(end date) THEN YEAR(START()) * 12 + MONTH(START()) - (YEAR(start date) * 12 + MONTH(start date)) ELSE YEAR(end date) * 12 + MONTH(end date) - (YEAR(start date) * 12 + MONTH(start date))
Would someone kindly assist with helping me identify the errors with the following perimeters I have set?
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…
I'm using the Integration API 2.0 to list workspaces https://anaplan.docs.apiary.io/#ListUserWorkspaces /workspaces "Retrieves all workspaces a user has access to within the user's default tenant." I'm only assigned to 2 workspaces (which are the only ones visible in the UI also), but this endpoint is returning everything.…
