Crosstab Summary field

[americvish]

Hi,
i have a crosstab report, where i have to summarized the summary field according to the condition below:

IIF(Int(Count({RESOURCE.RES_TYPE}))>1,

IIf(DateValue ({RESOURCE.START_LCL_TS}) <= DateValue (CurrentDateTime), Count({({@source value})& " Values",Count({RESOURCE.PROJECTION_VALUE})& " Values"),

IIf(DateValue ({RESOURCE.START_LCL_TS}) <= DateValue (CurrentDateTime),
(IIf(IsNull(Average ({@source value})),"No Data",Cstr(Average ({@source value}),"0.##"))),
(IIf(IsNull(Average ({RESOURCE.PROJECTION_VALUE})),"No Data",cstr(Average{RESOURCE.PROJECTION_VALUE}),"0.##")) ) ))

But i am not able to summarize the field and getting repeated values. I tried modifying the the above condition
by taking out count and average function, it did not work.

I want to summary the field like

IIF(Int(Count({RESOURCE.RES_TYPE}))>1,
then count of the field
else average of the field.

Is there any way to summarize the field according to the condition above?

thanks