Hi,
need guidance with the following formula.
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS04 Product Details'.Product Family, SUM:'SYS07 Distribution Center Details'.Country]
Thank you
@neg177
You don't need to use SUM on Product Family, Anaplan will auto aggregate SKUs into Product Families. Correct formula should be:
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country]
I'm using the formula below and it is giving me the error that my dimensions do not match.
Please advice,
The system module that is used in the SUM should have share same list (level) as the source module of the data so that Anaplan can lookup the property of the list item. The SYS04 module that is used might not be at the same level as the INV01 module.
Still very confused. I created a Line Item that would have the same list as the source, but still contain my Distribution Center information (G3), but still giving me a error with the formula below. Please advice.
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Distribution Center]
Is this the correct formula. I created a Line Item in SYS08 Module and used a Line Item format of the list s G3 Distribution Center? Formula is below.
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Distribution Center]
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.
