Star symbol coming in the calculated item

[Nikhil Shenoy]

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.

[MFGF]

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.

[Nikhil Shenoy]

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.

[Nikhil Shenoy]

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?

[MFGF]

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.