Rounding Two place holders.

[Listerman]

My sql code reads as follows:

Total ATR: Round([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"

This will round to a whole.

When I try to set it to round to the tenth it fails.
I tried using
Total ATR: Round((([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"),2)

Any ideas?

 

[KenHigg]

Total ATR: Round((([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) ),2)& "%"

???

 

[Listerman]

Wow, you're right. Can't believe I was missing that. I was trying to round the whole code.
Thanks!

 

[KenHigg]

If you would have gotten it to work it'd been pretty cool -