Want to Count Average

[Sxbbb]

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.

[sidhiq91]

@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.