Formatting a crosstab summary from seconds to MM:SS
Posted on 2009-02-20
I have a crosstab set up based on a formula that determines the number of seconds between two dates, and then finds the median. It works correctly using the seconds value.
Cross-Tab Summarized Fields:
Median of @DateDiffSeconds
However, I would like it to display in MM:SS format.
If I use the formula to create a CTime, Median isn't an allowed summary type.
I can't find a way to change the way it's displayed based on the calculations. (Like Group names, having a formula for calculating as well as a seperate one for displaying.)