MAX value for secsToMMSS conversion in Hyperion

[Michael]

We currently have columns such as 'Long Ans Del' displayed in our historical reports as a (raw) value in seconds. The business line has requested a conversion from raw seconds to MM:SS. The conversion is easy enough in Hyperion. However, I cannot obtain a MAX value for this column in the "Total" row once I convert the value to MM:SS. When using the raw data values in seconds, I have no problems.

I assume that this is because the converted value is NaN. Does anyone know how to obtain a Max Value for this column using the converted values?

[Adam G.]

Michael,

If you can post (or email me) your bqy file with some sample data I'll give it a good crack, unless someone beats me to it.

[Michael]

After a trip back in time to talk to the original PS tech who created our reports, I have the function definitions. Any further help is appreciated as the MAX function for the column still will not work as intended.

[Michael]

Solution - The computed item must be added to the result set and the conversion done there NOT in the pivot table as was explained originally. If the computed item is part of the result set, then the MAX function works correctly (even on an item converted the MM:SS)