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
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on this…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
