How to count the Column value rows where Value is "Yes"

Dear Experts,

I have a report in which there is a column which has a value of Yes or No.

I want to count the value Column rows where Value is "Yes"

Please let me know how to do?

Thanks & Regards,

 

Sir,

I have made the below function, which counts the total entries/row and displays in message.



[Function: EntryCounterYes]
Variable : TotalEntries : Number
Variable : Count : Number

100 : Set : TotalEntries : $$NumItems:FranchiseeDetailReportCollection
110 : Walk Collection : FranchiseeDetailReportCollection
111 : If : Not $$IsEmpty:$FraStatus
120 : Increment : Count
121 : END IF
130: End Walk
131 : Msg Box : "Total No. of Entries as Yes" : ##Count


[Button :ActiveFra]
Title :"Active Fra"
Key :Alt+Z
Action : Call: EntryCounterYes


But I want to count only those rows which contains Yes in $FraStatus. Like instead of Not $$Empty:$FraStatus I want do :$FraStatus Contains Yes or $FraStatus=Yes.

I don't know how to do that, please help..

Regards,

 

Take a field for it instead of button or walk

 

Sir, I am new to code , I don't know how to do ? please do it for me if possible...

 

Sir,

please have a look at the below code, it is working, but instead of all the row I want only Yes rows count, Can i Add some formula here and how?

Local : Field : FraStatus : Set As : $$NumItems:FranchiseeDetailReportCollection

but i want to add @@YesCount formula.

Regards,

 

Sir, I don't know how to join formula with collection like..

Local : Field : FraStatus : Set As : $$NumItems:FranchiseeDetailReportCollection@YesCount

is it correct?

 

Sir,

Initially it was copied but now I understand that code and have done modifications accordingly..
but
Mr. Jay says use field instead of functions and it is working fine with collection, it is only one line code
but
I am not able apply filter when i apply filter collection, result shows nothing.
What i could understand that either the way i am trying to use formula is incorrect or my complete approach is wrong.

Please help...

 

Sir,

Since original collection contains both Yes and No entries, so i created new collection and used filter for Yes entries and it is working fine, but I know that this is now the right way, there must be some simpler way to do it.

Local : Field : FraStatus : Set As : $$NumItems:FranchiseeDetailReportCollectionYesCount

original collection with yes and know
[Collection:FranchiseeDetailReportCollection]

Type : Ledger
Filter : ForFra
Sort : Default : -$FraLedStatus, $FraLedAgrEndDate, $FraLedName
Search Key : $FRALedCode
Fetch : *.*

New collection to count yes
[Collection:FranchiseeDetailReportCollectionYesCount]

Type : Ledger
Filter : YesCount
Sort : Default : -$FraLedStatus, $FraLedAgrEndDate, $FraLedName
Search Key : $FRALedCode
Fetch : *.*


[System: Formula]

ForFra : $FRALedCode <> ""
YesCount : $FraLedStatus = Yes

Regards,