Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Michael on March 05, 2009, 08:50:48 PM

Title: MAX value for secsToMMSS conversion in Hyperion
Post by: Michael on March 05, 2009, 08:50:48 PM

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?

Title: Re: MAX value for secsToMMSS conversion in Hyperion
Post by: Adam G. on March 05, 2009, 09:40:28 PM

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.

Title: Re: MAX value for secsToMMSS conversion in Hyperion
Post by: Michael on May 11, 2009, 07:40:44 PM

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.

Title: Re: MAX value for secsToMMSS conversion in Hyperion
Post by: Michael on May 14, 2009, 01:17:17 PM

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)