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. :)
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
Hi, I have the following problem to solve and I’m not sure whether it’s even possible in Anaplan. I have List A with a certain number X of elements. For selected elements from List A, based on which I create a subset, I determine the components that make up each element. There can be a maximum of 6 components. Each line…
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
