How to display 0 Percentage in BEx Query Designer

[Former Member]

The BEx queries which I'm doing are ported to EP & client views all charts & data in portal only.

I have a small requirement. My client requires to display 0% in the data output.

Sample data is like

Mon/Grade A | B | C | D | E | F " These are headings

April | | | 3 | 5 | 4 | | " These are data I got in BEx

Required O/p

Mon/Grade A | B | C | D | E | F " These are headings

April | 0 | 0 | 3 | 5 | 4 | 0 | " These are data I got in BEx

My current formula is like

> NODIV0( ( TEST1 * 12) %A TEST2 )

What changes must I make so that 0% is displayed in the O/p? Please let me know earliest.

P.S . The values TEST1 and TEST2 are 'Selections', which holds no data for those displaying values.

[Former Member]

Issue resolved. Solution: Use Decimals.

[Former Member]

HI Arun,

I am not sure if this works or not, but you can give this a try:

Include your existing formula in a bracket and add 0 to it.

Regards,

Umesh.

[Former Member]

Hi Umesh,

Could you give me an example. I tried something like this.

>COUNT( X) * My Forumula

>i.e. COUNT (X) * NODIV0( ( TEST1 * 12) %A TEST2 )

But, it yeilds no values. Could any one help with this?

[Former Member]

I was suggesting a simple change like:

(NODIV0( ( TEST1 * 12) %A TEST2 )) + 0

Regards,

Umesh.

[Former Member]

Still I need % symbol right, which can be got iff there's %A factor

[Former Member]

Hi,

In BEX you have to take the option don't supress '0' values.

Thanks,

[Former Member]

Hi Kavitha,

The problem is I'm viewing the data in Web based BEX & not in BEX Analyser. So only.

> GROUP E GROUP D2 GROUP D1 GROUP C2

>APR 6.0 46.0

>MAY % 14.3 48.0 11.4 16.9

>JUN % 11.6 16.2

As you can see there's no data for the months-grade (Apr-GroupD1 etc).. Now, how to view it in portal with 0s for all the ones with no data?