Formula related to ITEM() in the same List


Hi Everyone,

I am trying to summarise and collect data from numbered list input module.

I want the formula in the Item "COGS" in the COA list to refer to Item "Revenue" also in the COA list but in the input module.

Line item is Amount (single line).

Appreciate your ideas and suggestions.

Thank you

Best Answer

    Answer ✓

    Hi @Dikshant ,

    I found the formula.

    Added Select in the formula.

    'v2 Input Transaction Trading Currency'.Amount[SELECT: COA.Revenue, SUM: '#Assign CoCcTP and BU'.Trading Partner, SUM: '#Assign CoCcTP and BU'.CC Trading Partner, SUM: '#Assign CoCcTP and BU'.Business Segment, SUM: '#Assign CoCcTP and BU'.Trading Currency]

    Hence the COA.COGS column in the Summary module can collect info from numbered list referring to COA.Revenue column in input module.

    Thank you


  • Dikshant
    edited January 8

    @TQYYDN1 What is the challenge with the current condition? ITEM(COA) = COGS THEN XYZ

    edited January 8

    Hi @Dikshant,

    The challenge is to combine the

    'v2 Input Transaction Trading Currency'.Amount[SUM: '#Assign CoCcTP and BU'.Trading Partner, SUM: '#Assign CoCcTP and BU'.CC Trading Partner, SUM: '#Assign CoCcTP and BU'.Business Segment, SUM: '#Assign CoCcTP and BU'.Trading Currency]

    with the formula that points to COA.Revenue in input module.

    Current formula only collect all info from the same COA.COGS in the input module.


  • @TQYYDNi,

    Can you share the module v2 Input Transaction Trading Currency and pivot of both modules v2 Input Transaction Trading Currency and V2 TP Co Summary Currency?