Crosstab's and no data

[Fadius]

I have a crosstab using Xi. The cross tab has Months as columns and divisions as the rows. The cross tab breaks down the average turn around time for each division for each month.

What I am wanting to do is for those months that a division may not have had any requests is to have the summary for that month display something other than a 0. SOmething to indicate no data for that month.

Is this possible?

 

[lbass]

Select the summary->right click->format field->display string->x+2 and enter:

if currentfieldvalue = 0 then
"No Data" else
totext(currentfieldvalue,2)//2 for two decimals;0 for no decimals

-LB