Hi,
How can we calculate the collection of Revenue for future week? See example below, our Week13 fy24 data is to be collected in Week18 Fy24.
Thanks in advance for helping.
Regards,
Tom
Hi Tom,
You could utilise your 'Week Count' line item and use POST function:
POST(Rev, Week Count)
Let me know if that works :)
You can also check also the OFFSET function: https://help.anaplan.com/offset-4f5a095c-0e7a-4f1a-b6ea-0ef8f88d6c3f
However, for any function you use, you need to know how many weeks in the future you need to take data. :)
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β¦
