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

Data Format - basis points

Started by WKar, 05 Nov 2008 12:19:15 PM

Previous topic - Next topic

WKar

I am comparing Gross Margin % and want to show it in basis points? How can I get to this?

Thanks

DanSev

Given that your gross margin percent is coming out to a decimal (1 - 100% , .01 - 1%), just multiply the gross margin percent by 100 (std percentage to basis points conversion). - and do not format the data (or format it as a number). You can do this in the data item of gross margin % or create a 'Basis Gross Margin %' which references the gm% and multiplys by 100.

WKar

Thank you for your response, so i understand the math to get to the basis points conversion, I guess I was hoping there was an Excel like functionality where basis points can be selected if you want only certain cells to be by basis points.  Here is a clearer picture of the look of the report:  In the same row, I need GM percentage for the actuals amount column and then basis points used for Budget comparision columns.

                         Actuals($)      Budget comparison

Gross Margin %        %                 basis points

How can I get them in the same row?  thx!

DanSev

If you make the basis points a seperate data item in addition to the gross margin % data item
(in the query) they can be placed on the same row.


List style

Product |  Actuals ($) | Gross Margin % | Gross Margin Basis

Crosstab Style:

                                       Year
                         Actuals | GM % | GM Basis
Product | P Line

WKar

thank you.

It looks like in your examples you put them in the rows and columns next to each other, I am looking for the calculated result row to have % and basis points where you dont see basis points in the rows or columns headers, but in the results.  Thats why I was hoping to just target one row/column intersection and make it do basis points.  Is that possible?
            Actuals  Comparison
Revenue  10        10%
GM %      5%       5 pts

thanks!

DanSev

If you are using a crosstab you can set the Define Contents property of a given cell to 'Yes' in which case you can put whatever you like in it (data item/report expression/cell value/...) This overrides the default calculated values put in all intersections.

WKar

Perfect, this is exactly what I need!  So I changed Define Contents to YES, how do I define it to the data item specifically?  I tried to drag and drop the data item on the cell, and it wants to take up the entire Measures box, I only need it for the one cell.

Also, if i want to add text "pts" how would I do that?

Please advise, almost there, thank you!

DanSev

Define contents to yes and drag a text box from the insertable objects pane into the cell. Put in some junk value (b/c you'll  change it). Change the text box's source type to data source - the gross margin basis data item. (You need to be unlocked to do this). Add an additional text box before that one with text 'Pts.'.

WKar

So, I unlocked it, dragged in a text item, selected the source type as "Data Item Value", then I chose my data item. No value is displaying. Am I missing something?  I pulled a text item for pts, and it shows, but not my numerical value.  I also did a mock up EASY calculation, just to see numbers return.

So there is no calculated result coming through, am i over looking soemthing?

Thanks so much!!!

WKar

This is still an issue for me.  Any thoughts on why a value wouldn't return? Is there a setting I need to change or something?

Appreciate the help!