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
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
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
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! 🙂
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
