Hi All,
For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?
@jimfeng5
If you don't already have a SYS module for the Inventory dimension, create one. Create a line item (formatted as a boolean) and name it "Sum for Regular". Click the boolean to true for all members that you want to be in this calculation (could be one, could be many).
In your module, the formula would be: If SYS Inventory.Sum for Regular then do the sum else 0.
Hope this helps,
Rob
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
