Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
One way is as below:
=count({<PRICE ={0,"=Len(Price)=0" }>} distinct ORDER_ID)
Try this
Count({<ORDER_ID = {"=Sum(PRICE) = 0"}>} DISTINCT ORDER_ID)
or
Count({<PRICE ={0}>+<ORDER_ID = {"=Len(Trim(PRICE)) = 0"}>}DISTINCT ORDER_ID)
Or this
Count({<ORDER_ID = {"=Len(Trim(PRICE)) = 0 or PRICE = 0"}>} DISTINCT ORDER_ID)