Skip to Content
0
Aug 15, 2016 at 03:55 AM

Negative counts

65 Views

Hi,

I am trying to use the below formula variable in an drop down input control as:

sample = if Quantity <> 0 then 0 else 1 // Number Type Measure

* Webi Output of Quantity KF:

54.22

0.83

2633.88

-328.65

0

323.82

-346.82

0

In an Input control drop down(sample) selection:

Case 0 :

= Count[Quantity] => 6 // This includes negative as well as positive counts

Case 1:

= Count[Quantity] => 2

The issue here is when i select case 0 in the drop down, the count numbers includes both negative as well as positive counts. Here what iam trying to achieve is to separate the negative counts which means i am expecting an 3rd case outputs only negative counts when i select it from the input control..

4th case that includes all the above cases. ALL selection by default in input control dropdown.

Regards,

Dinya.