Error in formula

praba71
praba71
in Modeling

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

Tagged:

Best Answer

  • einas.ibrahim
    einas.ibrahim
    Answer ✓

    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)

Comments

  • anirudh
    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

Categories