Right..
I spoke to Cognos Support and got informed Ratios as a standard is not part of Cognos.
so i worked it around and ended up with two data items.
DataitemA and DataitemB
what i want to do is show:
DataitemA : DataitemB
so the result will be for e.g 1 : 2
I have tried to create a third data item like so:
[dataitemA]+':'+[DataitemB] <--- this errors?
what widget from the tool box is best to join two data items? and what is the syntax?
try with:
[dataitemA] || ':' || [DataitemB]
Regards,
Bryan
It'll error if the data items are numeric and you're trying to concatenate it with a string because you're mixing data types. Your choices are either to display all 3 items in one cell or to cast the numeric items as char. Personally, I'd go with option 1 - unlock the report and in the place I want the ratio to show I'd drag in both data items and drag a text item between them for the colon.
thats exactly what i did, thank you.