Hi,
How can I sum my months to get the quarter value in another module?
My source module is using month, i turned off of the summary SUM for Time. (to save space)
My target module, i want to get the quarter value of my source.
Thanks,
Tom
@tompatrick.ting
Gotcha. In that case, you're down to a few options. The easiest will probably be MOVINGSUM.
MOVINGSUM(Bonus, 0, 0)
Your target module should be set to quarters. Anaplan will automatically sum the months from your source.
Hi @JaredDolich ,
I have tried that but i am getting zero value in my target module.
Source Module:
Target Module:
Regards,
You're super close. I don't see anything wrong with the summary methods. Since this is a formula, can you check that the allocation % is non-zero? Test your formula first by removing the allocation percentage from your formula to see if the bonus values are showing up.
As you can see your setup with the summary methods works fine.
Hi @JaredDolich
I want to turn of the SUM for time. In your screenshot, your source module summary uses time sum.
Thanks @JaredDolich - movingsum works !
In relation to getting the sales per quarter. Target Module : Account (List), Product (List), Quarter (List), Year (List)
Source Module : Account (List), Product (List), Month (Time)
I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the Quarter List to the Month Time. What am i missing?
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…
