Crosstab calculated member issue 1

[pomster]

Why did this happen to my crosstab??

I created the report last week with the two calculated members to the right.

I would have expected March figures to be after February.

The formula for 6 months Avg is:

average([
GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex),
GridValueAt(currentrowindex, currentcolumnindex-2, currentsummaryindex),
GridValueAt(currentrowindex, currentcolumnindex-3, currentsummaryindex),
GridValueAt(currentrowindex, currentcolumnindex-4, currentsummaryindex),
GridValueAt(currentrowindex, currentcolumnindex-5, currentsummaryindex),
GridValueAt(currentrowindex, currentcolumnindex-6, currentsummaryindex)
])



regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005

 

[CrystalizeCanada]

In the CrossTab Calculated Members expert dialog box there is an option to Insert Evaluation Before or After.

If Before is selected that may explain why it appears with the last month on the end.




Gordon BOCP
Crystalize

 

[pomster]

Thanks Gordon, you pointed me in the right direction.
The insertion formula was looking at a discrete date. Changing it to maximum(date) rectified the issue.

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005