I need to sum the elements of one column based on an element "text" of another column.
This text element isn't in a list so I can't use the function "Select".
What formula can I use ?
That part of the extracted transactional code should relate to a known entity, so you can make a list for all the values of that entity. Call the list "Seg 2" for example. You will then need another line item to do a FINDITEM to "Seg 2" using that extracted text; this line item can then be used to SUM with.
Thanks for your answer.
I created a list and a new line item with the function FINDITEM.
I made a new module without "applies to" and with Year time scale.
I wrote this formula :
And I have this error message :
Can you help me again ?
You need to add "Seg 2" as a dimension in your new module, then this formula will work. Later you can use Select formula to extract that aggregated cell in another module.