I have a cross tab.
As the cross tab prints its values, I have created three formula fields, one to check if a date is null, or has a value, and the total of values in the column.
For instance.
3/17
ddd123
eee456
total area
L= 2
R= 1
O= 1
L is the total # of entries in the column,
R signifies if ReceiveDate is not null (calculated field)
O signifies outstanding....a null value in the date field.
My receivedate is...
If Not IsNull(ReceiveDate) then 1
My outstanding is...
If IsNull(ReceiveDate) Then 1
When I run the report, my calculations are off. For one date I know I should have 3 outstanding (null date values).
My report is showing 1.
I must be doing the the outstanding wrong....
Any ideas....
As the cross tab prints its values, I have created three formula fields, one to check if a date is null, or has a value, and the total of values in the column.
For instance.
3/17
ddd123
eee456
total area
L= 2
R= 1
O= 1
L is the total # of entries in the column,
R signifies if ReceiveDate is not null (calculated field)
O signifies outstanding....a null value in the date field.
My receivedate is...
If Not IsNull(ReceiveDate) then 1
My outstanding is...
If IsNull(ReceiveDate) Then 1
When I run the report, my calculations are off. For one date I know I should have 3 outstanding (null date values).
My report is showing 1.
I must be doing the the outstanding wrong....
Any ideas....