conditional COUNT in FR4
Hi everybody
I have this table
AREA EXPEDIENT NAME SALARY
1 324235 John 1234.45
2 436645 Mary 7843.23
99 346346 Rick 4656.98
etc
I know how to print all records in the table grouped by AREA including a COUNT agregated function in GroupFooter and ReportSummary bands but it counts all records however I ONLY want to count the records which ARE NOT of AREA=99
I've been Googling but to no avail
Sorry for my English
Thanks
I have this table
AREA EXPEDIENT NAME SALARY
1 324235 John 1234.45
2 436645 Mary 7843.23
99 346346 Rick 4656.98
etc
I know how to print all records in the table grouped by AREA including a COUNT agregated function in GroupFooter and ReportSummary bands but it counts all records however I ONLY want to count the records which ARE NOT of AREA=99
I've been Googling but to no avail
Sorry for my English
Thanks
Comments
[SUM(IIF(<YourDatasetName."Area"> <> 99, <YourDatasetName."Salary">, 0), MasterData1)]