SAP BO how to count the number of IDs in a cell

[former_member609320]

Hi everyone,

I am relatively new to SAP BO and have an issue that looks as follows:

In a table, there is a dimension which displays all IDs referred to an issue. Each of these IDs have 7 characters and are separated by a comma but displayed in the same cell always.

Column A:

1230000

1230001

1230002,1230003,1230004,1230008

1230005,1230006

Now I would like to create a Column B:

1

1

4

2

The count function doenst work as Column A is displayed in one string each no matter what the actual number of IDs are, thus it shows 1 no matter whether there are 1 or 20 IDs in the cell.

Does anyone have an idea?

Thank you for your support.

Regards,

Jonas

[denis_konovalov]

I have fixed your secondary tags to match your question better.

[Tom_N8 · Accepted solution]

Hi Jonas,

Try by creating a new variable:

[Count Concatenated IDs] =Length(Replace([Column A:];",";""))/7

This is provided your IDs always have the same length, i.e. 7 as in your example.

Kind regards,

Tom

[former_member609320 · Accepted solution]

Hi Tom,

thank you so much for your help! It works as intended.

I have seen that you replied to my other question as well but I havent checked that solution yet and will come back to it in a few minutes. Thank you again for your help, this works perfectly fine for me as all IDs have the same lengths.

Regards,

Jonas

[former_member609320 · Accepted solution]

Thanks Tom, everything works as intended!