How to calculate a percentage of a text Value ?

[bouderbc]

Hi experts,

How to calculate a percentage of a text Value ?

Example:

I need to calculate in the column Toto the percentage of value that contains 'Toto' ?

what do i use ? Textcount('Toto')/ TOTAL(Toto) ?

Thank you

Regards

Ali

[Anil_Babu_Samineni]

How to calculate a percentage of a text Value ?

I am not understading?

[sam_grounds]

Hi,

Simply use that value in set analysis...

Count({$<FieldContainingToto={'*Toto*'}>}MainIDField) / Count({$<FieldContainingToto=>}MainIDField)

You'll need to update the field names from above, but that should work.

Sam

[prieper]

COUNT(IF (Toto = 'Toto', Toto) / COUNT(TOTAL IF (Toto = 'Toto', Toto)

[sunny_talwar]

May be this

Count({<FieldName = {'*ToTo*'}>}FieldName)/Count(FieldName)

[bouderbc]

it doesn't work for me , do u have a sample for this (other example) ?

Thank you

[bouderbc]

it doesn't work for me , do u have a sample for this (other example) ?

Thank you

[sunny_talwar]

We probably can get across one, would you be able to share some raw data?

[bouderbc]

Hi Sunny,

in this example , i want to calculate :

The Percentage of KO

The Percentage of OK

The Percentage of OK by customer

The Percentage of KO by customer

[sunny_talwar · Accepted solution]

Check the attached