Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Nikhil Shenoy on 21 Dec 2017 06:09:21 AM

Title: Star symbol coming in the calculated item
Post by: Nikhil Shenoy on 21 Dec 2017 06:09:21 AM
Hi,

I am trying to create a crosstab which will have top 10 products based on Consumption %.
Consumption % is a calculated measure which has the formula of [Issues/(Opening Stock + Receipts)]
But whenever the data is either blank or 0 in any of these 3 fields, the Value in the Consumption % column comes with a * symbol in it. Attached is a screenshot.

Due to this I am not able to get adequate results for top 10 products.

Please help.
Title: Re: Star symbol coming in the calculated item
Post by: MFGF on 21 Dec 2017 06:24:44 AM
Quote from: Nikhil Shenoy on 21 Dec 2017 06:09:21 AM
Hi,

I am trying to create a crosstab which will have top 10 products based on Consumption %.
Consumption % is a calculated measure which has the formula of [Issues/(Opening Stock + Receipts)]
But whenever the data is either blank or 0 in any of these 3 fields, the Value in the Consumption % column comes with a * symbol in it. Attached is a screenshot.

Due to this I am not able to get adequate results for top 10 products.

Please help.

Have you checked the Data Format for this item to see if there is a "Zero Value Characters" or a "Divide by Zero Characters" option defined?

MF.
Title: Re: Star symbol coming in the calculated item
Post by: Nikhil Shenoy on 21 Dec 2017 10:23:05 PM
Checked the data format, it is defined as "Number".

But the "Zero value characters" and "Divide by zero characters" are not defined in the format.

Only following things are defined:
- Number of decimals
- Scale
- Negative symbol

Kindly suggest.
Title: Re: Star symbol coming in the calculated item
Post by: Nikhil Shenoy on 22 Dec 2017 03:12:54 AM
There was some issue in the data format due to which star was coming during aggregation. For top 10 products, I am trying the functionality available in cross tab, by clicking the Row and selecting show Top 10 based on Consumption %. But still its showing me cases where consumption % is "/0".
How do i exclude them?
Title: Re: Star symbol coming in the calculated item
Post by: MFGF on 22 Dec 2017 03:33:03 AM
Quote from: Nikhil Shenoy on 22 Dec 2017 03:12:54 AM
There was some issue in the data format due to which star was coming during aggregation. For top 10 products, I am trying the functionality available in cross tab, by clicking the Row and selecting show Top 10 based on Consumption %. But still its showing me cases where consumption % is "/0".
How do i exclude them?

I'd say you need to apply a filter [Opening Stock] + [Receipts] > 0

MF.
Text only | Text with Images