Business Objects Help and Count Function

[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

[daniel_paulsen]

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