Create a formula to calculate value, percentage and formatting in SAP BusinessObjects Web Intelligence 4.1
SAP BO Web Intelligence allows functions which help us to calculate cell value and formatting as per business requirement. Here I am explaining a simple step to write function and calculate value and percentage based on existing data column.I am assuming that query is added and now we have following data in in Webi report.
1. Add new column by right click on Sales Return Qty and insert column on right side.
2. Select new insert column and click on ‘Formula Editor’ on formula Bar or right click and Edit Formula.
3. Write formula =[Gross Sales Qty]-[Sales return Qty]’ to calculate Net Sales Qty.
Now we are getting desire output by formula.
Hope this blog gives clear understanding to use Formula in webi reports. And it is helpful.
Kashif Ali Khan