Hi Everyone,

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.

As per above report we have Sales Plan Qty, Gross Sales Qty and Sales return Qty and Now we have to calculate ‘Net Sales Qty’ and sales Performance based on Gross Sales, Sales Return Qty and Sales Plan Qty. follow below steps.

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.


4. Now add one more column to calculate Sales Ach % (formatting two digit decimal with %-symbol).  Go to Formula Editor then write formula ‘=FormatNumber(([Gross Sales Qty]-[Sales return Qty])/[Sales Plan Qty]*100;”##.00%”)’

Now we are getting desire output by formula.


Hope this blog gives clear understanding to use Formula in webi reports. And it is helpful.

Thanks,

Kashif Ali Khan

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Sue Kammann

    Kashif, How would you go about creating a line chart for the sales ach % by month?  I have done what you have done in step 4 with my data, but the percentage does not chart a line chart. 
    Can you walk thru the steps to make a line chart with that %?  Thank you.

    (0) 

Leave a Reply