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! 🙂
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
