Summing a formula field in a cross tab gives strange results

[sk8er1]

I have a cross tab that is giving strange totals.
The dataset contains a field named receiveDate. It can either have a value or not. I want to total each column with these values.

I have created 2 formula fields.

@Received =
If Not IsNull({receiveDate})or({receiveDate}<>Date(0,0,0)) Then 1

@Outstanding =
If IsNull({receiveDate}) or ({receiveDate} = Date(0,0,0)) Then 1

First of all, is the way to handle this. Second, how should they appear in the cross tab grid.

This is how the cross tab should look at the summation point. L is the total of values in the column. That works.
R is the values with date values... that seems to be ok...
O is outstanding... that value is wrong sometimes....


Total L: 16
Total R: 7
Total O: 9

 

[lbass]

Try placing the formulas in the detail section of the report to see if they are producing the results you would expect.

-LB

 

[sk8er1]

Its a cross tab. Its really strange. I will supply you with more details...

But when you say details section in a cross tab....what do you mean....

 

[lbass]

I am suggesting that you test your formulas outside of the crosstab environment to see if they are working as you expect. Place them in the detail section and see what they return.

-LB