If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

One "simple" calculation

Started by Wild Klaus, 31 May 2012 08:48:04 AM

Previous topic - Next topic

Wild Klaus

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

Wild Klaus

Сan someone know how in Format Setting to replace Decimal Separator "," (or other available) on ":"?
Example, instead of "1,2" - "1:2"?

blom0344

Perhaps you should consider casting the result to separate dataitems as varchar and concatenating them with ':':

[dataitem1]||':'||[dataitem2]

Wild Klaus

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