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

Accepted answers

TQYYDN1

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

All comments

Dikshant

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

TQYYDN1

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.

Thanks

Dikshant

@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?

TQYYDN1

Hi @Dikshant ,

I found the formula.

Added Select in the formula.

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

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!