Query Calculation if <1 then 1

[Wapug]

I have a field expression for a query as follows QR#:[TOTAL*0.02
this this obviously returns 2% of my total field. My desire is to get the number 1 if the result is less than 1. How would I go about this?

 

[Wapug]

sorry typo QR#:[TOTAL]*0.02

 

[sxschech]

if you literally want to have a number less than one be one, could you do:

QR_No:iif(([TOTAL]*0.02)<1,1,[TOTAL]*0.02)

 

[Wapug]

Thank you immensely!! I probably should know that but of course I didn’t. I appreciate your time.