Formula to sum with condition

Question

Hi,

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 ?

Thanks !

Best regards

ShubhamCh · Answer

Hi @OrfeaLEFEVRE

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.

Thanks!

-Shubham

OrfeaLEFEVRE · Answer

Hi Mark,

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 ?

Thanks

MarkWarren · Answer

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.