Compare rounded numbers

[Ciara]

Hi

I'm doing a calculation in a table that I want to compare to another calculation.  Both calculations result in a decimal number.

Is it possible to compare the rounded whole number of each? 

Basically in the first calculation, I'm getting 10.44 which when rounded gives me 10.

In the second calculation, I'm getting 9.63 which when rounded also gives me 10.

I want to colour condition the field so that if the first calculation (rounded) equals the second calculation(rounded) then highlight in green.

I've searched around but can't quite find what I'm looking for.

I've tried rounding each calculation, I've tried the Ceil function (but realise this is not what I need) and I've tried the num function.

Thanks for any help.

Ciara

[Saravanan_Desingh]

Try Round()

Round(10.44)=10
Round(9.63)=10
Round(9.33)=9

[Ciara]

Hi Saran

Thanks for your response. 

The round function actually did work eventually.  I had my parentheses in the wrong place.

Ciara

[Chanty4u]

Try this 

Round(your field)

For colour: 

IF(Column(1)=Column(2),Green(),Red())