Formula on summarized fields in crosstab? 1

[dunlop1975]

CR2008

I have a report that needs to calculate the average of a variety of time fields.

I've done the conversions to time->decimal value and properly created a weighted average crosstab (or seem to have).

My problem is I was to convert the decimal value for the time averages back to the proper time format for display in the crosstab. I have the forumula to use but cannot figure out how to use this on the crosstab (or if it is possible)

 

[lbass]

You can right click on the current crosstab value->format field->display string and enter the formula there.

-LB

 

[dunlop1975]

thank you, it has been so long since I made a non manual crosstab