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