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.
Hi,
In BEX you have to take the option don't supress '0' values.
Thanks,
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?
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.
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?
I was suggesting a simple change like:
(NODIV0( ( TEST1 * 12) %A TEST2 )) + 0
Regards,
Umesh.
Still I need % symbol right, which can be got iff there's %A factor
Issue resolved. Solution: Use Decimals.