Formula to sum with condition

OrfeaLEFEVRE
OrfeaLEFEVRE
edited November 2022 in Modeling

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 ?

 

OrfeaLEFEVRE_0-1667820129703.png

 

Thanks !

 

Best regards

 

 

Tagged:

Answers

  • MarkWarren
    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
    OrfeaLEFEVRE
    edited November 2022

    Hi Mark,

     

    Thanks for your answer.

     

    I created a list and a new line item with the function FINDITEM.

     

    OrfeaLEFEVRE_3-1667831623633.png

     

     

    I made a new module without "applies to" and with Year time scale.

    OrfeaLEFEVRE_2-1667831537850.png

     

    I wrote  this formula : 

     

    OrfeaLEFEVRE_0-1667830544656.png

     

    And I have this error message :

    OrfeaLEFEVRE_1-1667830646949.png

     

    Can you help me again ?

     

    Thanks

     

     

  • ShubhamCh
    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. 

     

    Thanks!

    -Shubham

Categories