SUM Formula Error

Options
Monpero
edited March 11 in Modeling

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)

© I have the summary module Dimensioned by Categories & Version & Time (Monthly)

(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

Best Answer

  • Tiffany.Rice
    Options

    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

Answers