set Analysis help

[arusanah]

Hi Team ,

I am trying to count records  where price is 0 's or blank or nulls  . I used below expression but it just returns data with price 0. 

count({<PRICE ={0,' ' }>}distinct ORDER_ID)

how can I modify above expression to pull records for nulls and blanks rows too ?

[kushalthakral]

Hi Arusanah
Can you please post sample records so that i can help you on this

Thanks
Kushal

[kushalthakral]

Hi 

You can use the follwing Set Expression

=Count({<Price = {0}>+<Price = {''}>}OrderID)
+
Count({1-<Price = {"*"}>}OrderID)

I hope this answers your question

Thanks

Kushal

[trdandamudi]

One way is as below:

=count({<PRICE ={0,"=Len(Price)=0" }>} distinct ORDER_ID)

[sunny_talwar]

Try this

Count({<ORDER_ID = {"=Sum(PRICE) = 0"}>} DISTINCT ORDER_ID)

or

Count({<PRICE ={0}>+<ORDER_ID = {"=Len(Trim(PRICE)) = 0"}>}DISTINCT ORDER_ID)

[sunny_talwar]

Or this

Count({<ORDER_ID = {"=Len(Trim(PRICE)) = 0 or PRICE = 0"}>} DISTINCT ORDER_ID)