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