Formulating a Expression

VishalSingh18 — Sat, 16 Nov 2024 02:04:33 GMT

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%

Re: Formulating a Expression

VishalSingh18 — Fri, 01 Nov 2019 09:55:02 GMT

its done problem was resolved