Season's greetings all.
I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows;
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]
Is there a logic context error here somewhere that I am overlooking? Any help would be greatly appreciated. Thank you.
HI @roblund,
I think the line item is present in the INV02 Country Summary as Safety Stock flag count - Formula 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country Made In].
The formula is exact. Check with the format. Also if you can attaché the error that you are encountering that would help us to find the exact issue. Also please check the line items names that should match in the formula(Capital letters, small letters or spelling check)
Without seeing the error message it is challenging to give you an exact answer.
However, check through the following;
The above checks form the key bridge in connecting the source dimensions with those in the target. Without them the SUM functions will simply not work. If this is the case you should receive a mismatch of dimensions error.
Here is a link to the SUM section of Anapedia - https://help.anaplan.com/27935be6-48ba-47a2-bdd6-117d225e1b02-SUM
Chris
Thank you. Figured it out weeks ago but I do appreciate you checking in