Those blank cells are not actually equal to 0. They have a different value. What you can do is hide the current key figure and replace it with a calculated key figure which is equal to your hidden KF + 0. This will then display those blank cells as 0.
Hope this helps!
Thanks for Quick Reply,
Actually I am getting the Empty cells for the Calculated KF it self, I have followed the given suggesition , but still getting the Empty cells
Actually my CKF was ,
Basic KF ZFORECAST (Hide)
Calculate KF (NODIM(ZFORECAST)/ 1000)+0
I have used the above one,
Could you give me the alternative Solution for this ...
Thanks in Advance...
After calculation if ur getting few of ur cells empty even the desired is 0 then in this case u have to create 2 more Calculated key figure and to write something like this in ur Figure:
Suppose the blank ciolumn name is KF1
Then create a KF2 and type below formula:
in KF2 write : KF1 + 1.
Now create another KF3 in that use the below formula:
(KF2 == 1) * 0 + KF1.
KF3 wil be ur final column then,
As the blank space is not zero so directly adding 0 to that will not serve to ur purpose u need to create two more KF as suggested above.
Its a common problem faced as such there is no settings for this so need to do little +, - with Zero so that u can get the 0
Tried several alternatives of this approach; it does not work for BW 3.x.
This persistent problem got to do with the difference between null values (blanks/empty cells) and zeros set up internally in the SAP system within the Infoproviders. Interestingly, zeros are more expensive (they take more disk space in the database), bigger in size than blank/empty cells.
The solution could be to upgrade to a newer version or use a macro to do the conversion in your report.
Hi Adwin ,
I have tried the below one , but getting error like .. Formula not defined correctly,
I have checked the Basic KF Values in the Infoprovider level, there I have zero values ...
and tried to create a Formula variable with default value '0' and added to the Calculated KF , then also I am getting the empty cells,
Please let me know any possible solution
Thanks in Advance ...