Skip to Content
0
Former Member
Oct 30, 2005 at 01:13 PM

How to differentiate between null and 0

54 Views

Hi everybody,

when calculating an average I need to distinguish between figures submitted through manual input as 0 and the case "no figure submitted".

Example: amount accounts receivable outstanding aged > 60 days.

Company 1 submits:

Jan: 100

Feb: 100

Mar: 100

Q1 average: 100

Company 2 submits:

Jan: 100

Feb: no submission

Mar: 100

Q1 average: 100

Company 3 submits:

Jan: 100

Feb: 0

Mar: 100

Q1 average: 67.67

Does anybody have any clever idea on how to solve this?

Thanks in advance,

Martin