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! 🙂
Is there any way to have the last item of the waterfall be a running total that starts from 0 and shows the net of the previous waterfall components? I'm using line items here, would just want the Ending NAV to always start at 0
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
