SUM Formula Error

Hi All,

(a) I have an input module dimensioned by CC & Categories & Version & Time (Quarterly)

(b) I have 2nd module dimensioned by CC & GL & Version & Time (Quarterly)

(d) I have a mapping module of CC & Categories

FINAL RESULT

(Categories) Module C Line Item result = module A[SUM: module d] * module b (Dimesioned by categories , time(Quarterly) and Version)

Module C final result = (Categories) Module C / 3

But it gives me this error. Please how can I get the numbers to module that is dmensioned by Categories

ERROR

Below is my formula

Please how can I resolve this issue. Thanks

Accepted answers

Tiffany.Rice

I think the issue is in module d. Typically a mapping module will contain a single dimension (CC) and then you leverage a line item formatted as the list you seek to map (category). You seek to define the relationship between CC and category in that line item. Quick mock up below to illustrate

All comments

Tiffany.Rice

Monpero

Thanks very much @Tiffany.Rice it makes sense.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…