Delimit not working

[nickmarlborough]

Hi, 

Have a table:

Company	100
A	10
A,B	20
C	30
D,G	40

I want it to be (the 100 is a distinct count of the IDs in question)

Company	100
A	20
B	20
C	30
D	40
G	40

when i do a subfield in the table itself it changes the number from 100 to less - so doesnt work...

[marcus_sommer]

It's not quite clear what do you want to reach but subfield() seems to quite suitable to split the records - and a substringcount(Company, ',') + 1 returns the number of substrings. On top you may need some further measures to check the first/min/max value and/or dividing the amount through the number or ...

[Anil_Babu_Samineni]

@nickmarlborough Can I know why this record not counted in desired result?

Company	100
A	10