Want to Count Average

Sxbbb — Sat, 22 Oct 2022 03:13:05 GMT

Average compared to Upper and Lower If the value is between Upper and Lower count ( green numbers). If the value is not between Upper and Lower count the red numbers.

Re: Want to Count Average

sidhiq91 — Sat, 22 Oct 2022 15:03:31 GMT

@Sxbbb Firstly use the below script in the back end:

NoConcatenate
Temp:
Load * inline [
Average,Upper Limit,Lower Limit,Accept,Reject
45.62,52.01, 42.99,40,0
35.62,52.01, 42.99,40,0
];

NoConcatenate
Temp1:
Load *,
if(Average>[Lower Limit] and Average<[Upper Limit],'Accept','Reject') as flag
Resident Temp;

Drop table Temp;

Exit Script;

Then use the Expression as show below in the front end:

If this resolves your issue, please like and accept it as a solution.

topic Re: Want to Count Average in App Development

Want to Count Average

Re: Want to Count Average