Aggregation

[Anonymous]

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

[Gysbert_Wassenaar]

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"?

[el_aprendiz111]

Hi,

1 option

in the script

LOAD *, IF([Delivery Number]=0,1,0) AS COUNT_DEL;

and expression =SUM(COUNT_DEL)

[Anonymous]

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?

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

Try this: Count({<Cost={0}>} Distinct [Delivery Number])

[Anonymous]

yes like to do it in front end .More over the Gysber Wassenaar provided me right answer thanks .