Rounding problem

[#1]

I have one expression like overall days in my straight table.

It is showing the values in straight table like

345

356

323

123

555

123

But when i am exporting to excel it is showing the values

345.6

356.4

323.1

123.6

555.2

123.8

Now i am expecting the output when i am exporting the excel is like below.

346

357

324

124

556

124

Please advice.

Thanks for help in advance.

[nagireddy_qv]

Hi

use Money(),round() function in your expression.

[arulsettu]

ceil(your expression)

for ex:

ceil(sum(sales))

[sunny_talwar]

May be use this:

Ceil(YourExpression)

[swuehl]

What number format settings are you using on number tab in chart properties? I believe setting the format to integer should do what you want.

Could you post a small sample QVW?

edit: Missed that you do want to round upwards. Do you really want to do this?

[Chanty4u]

round(urfield)

round( 2.4 ) returns 2

round( 2.6 ) returns 3

round( 2.5 ) returns 3

round( 3.88 , 0.1 ) returns 3.9

round( 3.88 , 5 ) returns 5

round( 1.1 , 1 , 0.5 ) returns 1.5