Error in formula

Highlighted
Contributor

Error in formula

Hi

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

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Error in formula

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
Highlighted
Valued Contributor

Re: Error in formula

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

 

image.png

 

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.

 

image.png

 

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

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"