Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Carrier_Code, Delivery Number ,Ship date and Cost.
Some of the Delivery numbers are not are rated or the cost =0.
Now I need the count of Non Rated .
Please provide me aggregation
Try this: Count({<Cost={0}>} Distinct [Delivery Number])
Some of the Delivery numbers are not are rated
Now I need the count of Non Rated .
Define "Non Rated". What are the conditions that determine a Delivery Number is "Non Rated"?
Hi,
1 option
in the script
LOAD *, IF([Delivery Number]=0,1,0) AS COUNT_DEL;
and expression =SUM(COUNT_DEL)
Do you mean that the delivery Number is blank when you say non rated?
Would you like to do it in script or on the front end only?
Can you post sample data perhaps?
Hi,
Not Rated is like :
All the Delivery number should carry a cost.
but some delivery number doesn't have the cost or the cost is 0.
When the cost is 0 it is Non rated.
count(distinct(Delivery))-Aggr(count(distinct ShipDate),Cost,Delivery)
I have written it in a Expression in UI but not sure it is right
Try this: Count({<Cost={0}>} Distinct [Delivery Number])
yes like to do it in front end .More over the Gysber Wassenaar provided me right answer thanks .