Round function

[Unicon]

Daer all,

How do I use Round Function in query? As I put below function in my query but its showing (53.5384) Which I want to show 54 only.

NonDeployedDaysEarned: Round([BasicAsPerState]+[StateFoodAllowance])/26*[NonDeployedDays]

Please advice.

 

[John Big Booty]

Try;

NonDeployedDaysEarned: Round[COLOR="Red"]([/COLOR]([BasicAsPerState]+[StateFoodAllowance])/26*[NonDeployedDays][COLOR="Red"])[/COLOR]