Distributing Key figure values into colums using formula

Distributing Key figure values into colums using formula in BEx

 

Scenario : Distribute Keyfigure values into formula elements and reprsent them in report by separate coulmn.
suppose the key figure is having 0 to 500 values then i want to make a distribution as follows:
0-50 formula 1
50-100 formula 2
100-200 formula 3
and so on--

Solution: Using boolean options in BEx we can achive this.
Create new formula and use one of below conditions:



Formula1 : ((keyfigur) => 0 * (keyfigure) <= 50) * keyfigure
Formula2 : ((keyfigur) => 51 * (keyfigure) <= 100) * keyfigure
Formula1 : ((keyfigur) => 101 * (keyfigure) <= 200) * keyfigure
Formula1 : ((keyfigur) => 20 * (keyfigure) <= 300) * keyfigure
and so on ....

More info refer to link : https://forums.sdn.sap.com/thread.jspa?threadID=635618&tstart=0


RELATED POSTS

Career Center	Career Center
Central Process Scheduling	Central Process Scheduling
Chemical Industry	Chemical Industry
Coffee Corner	Coffee Corner
Composite Application Framework	Composite Application Framework
Composition Environment	Composition Environment
CRM - General Questions (See Note)	CRM - General Questions (See Note)
CRM - Interaction Center	CRM - Interaction Center
CRM - Marketing	CRM - Marketing
CRM - Mobile Applications	CRM - Mobile Applications
CRM - People Centric User Interface	CRM - People Centric User Interface
CRM  Sales	CRM Sales
CRM - Service	CRM - Service
CRM 7.0	CRM 7.0
CRM Master Data	CRM Master Data
CRM Middleware	CRM Middleware
CRM Web Channel E-Commerce, E-Marketing & E-Service	CRM Web Channel E-Commerce, E-Marketing & E-Service
CRM Webclient UI - Framework (SeeNote)	CRM Webclient UI - Framework (SeeNote)