7 Replies Latest reply: Sep 17, 2010 5:18 PM by Arun Bala RSS

How to display 0 Percentage in BEx Query Designer

Arun Bala
Currently Being Moderated

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.

Actions