Count in a report with if criteria (1 Viewer)

R

Runes

Registered User.

Local time

Today, 01:41

Joined

Feb 11, 2010

Messages

20

• Jun 15, 2017

• #1

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

AWF VIP

Local time

Today, 02:41

Joined

Jul 2, 2005

Messages

13,826

• Jun 15, 2017

• #2

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.

 

R

Runes

Registered User.

Local time

Today, 01:41

Joined

Feb 11, 2010

Messages

20

• Jun 15, 2017

• #3

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

 

isladogs

MVP / VIP

Local time

Today, 09:41

Joined

Jan 14, 2017

Messages

18,219

• Jun 15, 2017

• #4

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