Total account query

[azhar2006]

Hello guys
I've calculated my job query total student grades and then shows me the stairs rate, which works just fine.
But I want an additional field a(Expr2) as in the picture. The thus: -
If the rate is less than 50 shows me zero.


Any help ... Thanks in advance

[alansidman]

In the new field: Expr2=IIF([Rate]<50,0,Int([Rate])

[JamesDeckert]

expr2:iif([Total score]/4<50,0,[Total score]/4)

[azhar2006]

Thank you very much, my friend JamesDeckert