Count rows where Field 1 = field 2

[jgreen95]

I have a table and want to count the rows only where field 1 = field 2?

anyone who a function that works for this?

[Stoyan_Terziev]

Hello,

You want to do that on the Back-end or the front end? (I expect you need the number in one single cell, in a single column)

Back-end approach would be:

Count:

LOAD

SUM(Count) as Count

;

Load

If([Field 1]=[Field 2],1,0) as Count,

RowNo() as Index

RESIDENT SourceCounted

;