Display dimension value when measure #EMPTY value in DP

building reports desktopintelligence
1

In drill mode on a chart, with week on X axis.
All week/customer are in DP but sometimes with #EMPTY values, how can I even display 0 for this week when i drill down to a specific customer ?

Thks,

Gautier.

geuth :fr: (BOB member since 2003-05-12)

2

change the format. Right click on the cell, select Format Cell, change undefined to 0…that should do it.

Justin Grimme :us: (BOB member since 2004-03-03)

3

Unfortunately I am not working on table but really on charts.

Thks,

Gautier.

geuth :fr: (BOB member since 2003-05-12)

4

Instead of using the measure object directly, create a variable with the formula:

= If IsNull(<measure>) Then 0 Else <measure>

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

5

It works fine now, thks a lot.
Gautier. :slight_smile:

geuth :fr: (BOB member since 2003-05-12)

6

This topic has been out here for a long time but I am having an issue with the #EMPTY values in my chart as well.

I have a simple Line chart plotting 4 measures. All of the measures bring back 12 months data except for one. That one is the current year so right now only 8 months of data is being returned and months 9-12 the amount is #Empty.

When the values for the current year are #empty the line will not be displayed. If I change and use a variable to change them to zero’s then the line is displayed but months 9-12 are plotted as zero.

Management does not want to see the current year line plotting zero for the months that have not happened yet.

I tried applying a filter on the current year measure for Greater Than zero but then all the lines being plotted stop at month 8.

Can anyone offer any help on this? I need the full year lines to plot all 12 months but only want the current year line to plot to the last month in which there is data.

Thanks.

estaup (BOB member since 2002-10-15)