Month to Date Formula

hinamahmood1994

Hello,

I'm trying to use month to date formula. It doesn't look like it's working correctly.

cumulative amount should never decrease if i'm adding values month on month.

Thanks

month_to_dat_formula_48172.PNG

Accepted answers

DavidSmith

The MONTHTODATE function will reset each month, so I'm guessing the summary options you have set are different for the different line items

If you want the values to cumulate each month and reset at the end of the year, then use YEARTODATE, otherwise use CUMULATE

I hope this helps

David

All comments

DavidSmith

The MONTHTODATE function will reset each month, so I'm guessing the summary options you have set are different for the different line items

If you want the values to cumulate each month and reset at the end of the year, then use YEARTODATE, otherwise use CUMULATE

I hope this helps

David

usman.zia

Hi @hinamahmood1994

The month to date formula has the following constraints:

- Source Time Scale must be Day or Week.
- Cannot be used, if model timescale is General Weeks.

Therefore it's best to follow @DavidSmith advice to use the YEARTODATE or CUMULATE functions.

Thanks,

Usman

hinamahmood1994

So it was originally yeartodate. Since it wasn't showing right numbers I changed it. Realised issue was time summary needed to be close balance instead of sum. That fixed the issue.

Thanks for your help! 🙂

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…