Account or Subsidiary Not Aggregating
Summary:
Content (please ensure you mask any confidential information):
I have the below data that was loaded at a base level in Forecast, but it is not aggregating up to the Parent Subsidiary. The aggregation rule has all 13 dimensions included. I can't figure out what I'm missing?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
TS=total subsidiary
FIX(@RELATIVE ({Account},0), @RELATIVE ({Period},0),{Year}, {Scenario},@RELATIVE ({Version},0), @RELATIVE ("Amount",0),@RELATIVE ("TS",0))
FIXPARALLEL(4, @RELATIVE ("Currency",0) )
AGG("Department","Relationship","Item","Location","Class");
ENDFIXPARALLEL
ENDFIX
Tagged:
0