Error in formula

Seems to be a minor one, but I am not getting it..I am getting invalid error for the formula in the attached screenshot.

Can you please help to fix it?

Thanks

Regards

Prabakaran

Screenshot_2020-07-11_at_12_76666.png

Accepted answers

einas.ibrahim

Hi @praba71

For the SUM to work, the line items you use to SUM ( what comes after [SUM:...] in your formula, have to be of a list format matching a dimension in your target module

This means that Organization Code(Mapped) and Config LF line items should have the format List, and the Lists should be Dimensions in your target module Comp Demand Analysis

You can read about how SUM works here.

If the table with the example is not clear, let me know and I'm happy to explain further (or in a different way)

All comments

anirudh

Hi Prabakaran,

Try inputting only "Comp Incoming Inprocess Demand.Order Open Qty" only into the formula
If that resolves successfuly, add the first SUM into the formula, then add the second one

That should allow you to debug

Regards,
Anirudh

einas.ibrahim

Hi @praba71

For the SUM to work, the line items you use to SUM ( what comes after [SUM:...] in your formula, have to be of a list format matching a dimension in your target module

This means that Organization Code(Mapped) and Config LF line items should have the format List, and the Lists should be Dimensions in your target module Comp Demand Analysis

You can read about how SUM works here.

If the table with the example is not clear, let me know and I'm happy to explain further (or in a different way)

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…