COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Wild Klaus on 31 May 2012 08:48:04 AM

Title: One "simple" calculation
Post by: Wild Klaus on 31 May 2012 08:48:04 AM
I have an indicator of how late the event occurred. It is measured in hours. I need a KPI as a mean value. There are no problems. The problem is in the format of values. I want to output the resulting average value in the format HH: MI. How can I do this? thank you
Title: Re: One "simple" calculation
Post by: Wild Klaus on 05 Jun 2012 06:57:07 AM
Сan someone know how in Format Setting to replace Decimal Separator "," (or other available) on ":"?
Example, instead of "1,2" - "1:2"?
Title: Re: One "simple" calculation
Post by: blom0344 on 07 Jun 2012 12:43:22 PM
Perhaps you should consider casting the result to separate dataitems as varchar and concatenating them with ':':

[dataitem1]||':'||[dataitem2]
Title: Re: One "simple" calculation
Post by: Wild Klaus on 08 Jun 2012 02:19:40 AM
Unfortunately, in this case the number is converted to text, not the average value calculated. I decided to go the other way - to replace the Decimal Separator ":", but the available no '". Maybe in the global settings this can be done - I do not know