Default value for empty record

[Former Member]

I have created a multiprovider to join the two cube (Plant A, and Plant B).

This report will list the Cost Center amount for both Plant. I have placed the Cost Center Characteristic in the MultiProvider and

Identified them with Plant A and B. I also placed the Key Figure Amount in the MultiProvider (KF PlantAmtA and PlantAmtB).

In the MultiProvider, the KF PlantAmtA is assigned to Plant A, and KF PlantAmtB is assgined to Plant B.

Now in the Query Designer, I have placed the Cost Center in the Row, and the two KF in the Row. When I run the query, I have the

following output:

Cost Center.....Amount A.....Amount B

100985...........1000 USD.....3000 USD

100986...........6050 USD.....

100989...........9020 USD.....3500 USD

I noticed that Cost Center 100986 does not exist in the InfoCube Plant B, and hence it is blank in the Amount B column.

Is there a way to force and default it as 0.00 instead of blank in the Amount B column?

Kindly advice. Thank you.

[Former Member · Accepted solution]

Hi

Pls create two calculated key figures based Amount A and Amount B and Display those calculated key figures in the report

Thanks & Regards

Rohit

[Former Member]

Dear Linda,

You can maintain settings at TCode: RSCUSTV4 . These settings are global, effects to all workbooks.

Or you can write a simple formula or calculated keyfigure.

Hope it Helps

Srini

[Former Member]

good info

[Former Member]

Hi Linda,

You can use formula for each key figure.

Formula for Amount A: "Amount A" - 0

Formula for Amount B: "Amount B" - 0

this might slow down your query performance depending on size of your report, as it will need to perform calculation for each row.

At the same time, you need to be aware of the unassign (blank or "#") meaning no values, not even zero, as zero is a value. For example, if one of your cost center has offset figures, e.g. +10 (credit) and -10 (debit)amounts for the same cost center, depend on the query details it will show zero due to these amounts offset each other. if you fix formatting issue by introducing forumla, you might not be able to tell if there are no values or the particular transactions contains offset amounts.

regards,