Archived discussions are read-only. Learn more about SAP Q&A

How to display 0 Percentage in BEx Query Designer

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.

Not what you were looking for? View more on this topic or Ask a question