Show null (zero) values in query

[former_member205151]

Hi Gurus,

Can I show in a query null values in cases that the InfoCube or dso doesn´t have records with values?

Example:

Sales Cube (with data records)

1 = 100,00

2 = 150,00

3 = 200,00

The InfoObject COUNTRY have 4 records (master data):

1 = Brazil

2 = India

3 = USA

4 = Jamaica

The InfoObject have 1 hierarchy:

COUNTRY

001 BRA

002 IND

003 USA

004 JAM

The query results is:

COUNTRY

BRA 100,00

IND 150,00

USA 200,00

JAM

I need to show in this case 0,00 to record JAM, but the query shows BLANK.

Can I do this?

Best Regards

Alex

[Former Member]

Try to create your calculated Key figure with data function NDIV0(x) or NOERR(x).

[Former Member]

Hi Alex,

yes you can do this. Create a formula and add your sales + 0.00. In this case your result will always have 0.00 even if there is no data in your cube.

Thanks.