Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%
its done problem was resolved