Formula to sum with condition

edited November 2022 in Modeling



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




  • MarkWarren
    edited November 2022

    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.

  • OrfeaLEFEVRE
    edited November 2022

    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 ?





  • ShubhamCh
    edited November 2022

    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.