Expand my Community achievements bar.

SOLVED

Round numeric field to z,z5 or z,10

Avatar

Level 1

I try to round a tax field, my FormCalc code is


Round((Field1 * Field2),2)

eg ((570 * 6.05%)

the result is 34.49 - it should get 34.5

if the result is 34.46 or 34,47 it should round down to 34.45

how do i resolve this rounding problem

I appreciate any help.

thank you

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

Try the following

Round(Field1 * Field2 * 2,0)/2

Good luck

Bruce

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi,

Try the following

Round(Field1 * Field2 * 2,0)/2

Good luck

Bruce

Avatar

Level 1

hi Bruce

Thank you for your answer I resolved it like this

Round(Field1 * Field2 * 2,1)/2

Thanks again,

Marianne