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 ALL, I'm using Product Category, Product Line, and Budget Type to generate a unique Code for a list. The display string is generated as: Product Category & "_" & Budget Type & "_" & Product Line. The Code is currently generated using: LEFT(Display String, 60) The issue is that Product Category and Product Line containsβ¦
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
