Forum Discussion

JayTG123's avatar
JayTG123
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Adding text together in one column

Hi all,    I am struggling with how to sum the individual values in the reasons_for_refusal column (screenshot below)   So what I am trying to achieve is the total of all rows which contains RC10...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Ideally, in the Query Editor, you should first use the Split column > By delimiter and in the Advanced optios, select rows.  This will ensure that each cell has only one reason.  Then you can write this measure

    Number of reasons = counta(Data[reasons_for_refusal])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Ideally, in the Query Editor, you should first use the Split column > By delimiter and in the Advanced optios, select rows.  This will ensure that each cell has only one reason.  Then you can write this measure

Number of reasons = counta(Data[reasons_for_refusal])

Hope this helps.