Formulating a Expression

[VishalSingh18]

Hello,

I need to develop a expression that respects the below condition

Definition: Number of items completed 100% / total number of items per route by date

Numerator: Total Items completed 100%

              Where ifnull(qty,0)>=ifnull(reqqty,0)

              In this example, we would count the records in blue as “loaded 100%”(that means qty>=reqqty) and we will record 14 as the numerator

Denominator

              Count(item)…….where date={date} and route={route} and item is not null

Final Result

              For this example, we would calculate 14/20 = .7 or 70%

[VishalSingh18]

its done problem was resolved