Skip to Content
0

Business Objects Help and Count Function

Jun 12, 2017 at 05:26 PM

78

avatar image
Former Member

Hello,

I could really use some help here.

I am looking at my company's safety stock settings vs. actual inventory. I created a variable to show three categories: current inventory is above our safety stock ("Above"), current inventory is below safety stock ("Below"), and if the item has no current inventory ("No Stock").

Here is the formula I am using:

=If [On Hand Balance Approved]=0 Then "No Stock" Else If [Safety Stock]>[On Hand Balance Approved] Then "Below" Else "Above"

The variable type is Text and I currently have the Qualification as Dimension since it isn't a number.

I would like to count the number of items that fit into the three categories but I am having difficulty trying to do this. Ideally I would like to make a pie chart with this data in the end, but a simple table will also work.

Thank you,

Drew

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Daniel Paulsen
Jun 13, 2017 at 11:55 PM
0

Hi Andrew,

I'm no expert with formulas but first wanted to confirm if you are trying to add this formula using the Webi SDK (you posted to the SDK tag) or are you trying to add the formula in the Report designer (HTML or Webi Rich Client).

If its just a general Webi design question, then try posting in the Webi tag: SAP BusinessObjects - Web Intelligence (WebI)

Dan

Share
10 |10000 characters needed characters left characters exceeded