I have a cross tab with Year/Month across the top and measures in the column. For the purpose of this example, say there are 24 columns representing the 24 months of 2007 and 2008. I’ve inserted two columns in the begging of the cross tab which will hold “Median” calculations.
In the 2007 col/row for the measure Transaction Count, I use this formula: “=Median(If(Year([Mailing Date])=2007;[.Trx_Count] ForEach ([.Mon_Year])))”. I checked the formula by downloading the table to Excel and performing the calculation there. All is good.
In the 2008 col/row for the same measure, I used the same formula, but changed the year to “2008”. However when I check the formula in Excel the calculation the BO is returning is incorrect.
I cannot understand why this is happening. I believe it’s got to be something with the data, because the formula is identical between the two years and all 12 months of both years have data values present.
Any thoughts?
DMagnus 
(BOB member since 2005-12-06)