Showing results for 
Search instead for 
Did you mean: 

Documents on Functions of Bex Formula

Former Member
0 Kudos

Hello Experts,

I dont have much expoure on Bex,

can any one send me some document on Bex forumal and its functions such as,

1,Basic function

2,persentage function

3,data function

4,math function

5,trignometric function

6,boolean function

and other function like (,/,*,(,),)

When to use these function.

My mail id is


Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi wajid,

A small tip:

Sometimes when you run a BEx query, you need to differentiate how to treat the key figures in your report. Say you want to view the individual costs of several items in your inventory as well as the total cost of these items. In your query formula, key figures like quantity and cost must act differently for individual values and aggregated values.

In this case, you could use leaf, a <b>Boolean operator</b> that permits you to perform calculations in results rows. You can use the leaf operator for formulas as well as calculated key figures. This functionality works with all releases of BW. You apply the leaf operator at the query level in BEx Analyzer