Count in a report with if criteria

[Runes]

Hi

In a report a want to Count the amount of dates in ColumnA that is before today and ColumnB is empty. Is that possible? The output should be a number.

Thanks

 

[RuralGuy]

One of the nice things about reports is you can have invisible controls in each row that can keep track of what you want. Then you can sum that invisible column in the footers.

 

[Runes]

So it is no function i can use, i want this number in a calculation afterwards.

 

[isladogs]

In that case, create a function that calculates those criteria and use that where needed - possibly also in the report

In the function, you would obviously need to refer to the fields used for columns A & B