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.