COUNT SPECIFIC WORD IN FORM

[ahamedmujahid92]

Hi,

I have to count Specific word ("Good & Not Good") in Form1. 

It means,
No of "Good" count should Reflect in Textbox or Label

No of "Not Good" count should Reflect in Textbox or Label

Please find the screenshot

[Sundeep_Malik · Accepted solution]

Hey @ahamedmujahid92 

In the text property of the label do this:

Good Label:

Sum(If(DataCardValue1.Text="Good",1,0),If(DataCardValue2.Text="Good",1,0).....Rest for other datacards...)

For Not Good Label do this:

Sum(If(DataCardValue1.Text="Not Good",1,0),If(DataCardValue2.Text="Not Good",1,0).....Rest for other datacards...)

[v-bofeng-msft · Accepted solution]

Hi @ahamedmujahid92 ,

Please try:

No of "Good" count should Reflect in Textbox or Label

If(Label1.Text="Good",1,0)+
If(Label2.Text="Good",1,0)+
If(Label3.Text="Good",1,0)+
If(Label4.Text="Good",1,0)+
If(Label5.Text="Good",1,0)+
If(Label6.Text="Good",1,0)+
If(Label7.Text="Good",1,0)+
If(Label8.Text="Good",1,0)

No of "Not Good" count should Reflect in Textbox or Label

If(Label1.Text="Not Good",1,0)+
If(Label2.Text="Not Good",1,0)+
If(Label3.Text="Not Good",1,0)+
If(Label4.Text="Not Good",1,0)+
If(Label5.Text="Not Good",1,0)+
If(Label6.Text="Not Good",1,0)+
If(Label7.Text="Not Good",1,0)+
If(Label8.Text="Not Good",1,0)

Best Regards,

Bof