assistance in round calculated filed in pivot table

[JEAN1972]

Trying to use calculated field to sum amount to e.g round(28.80,0) to show in round field 29 and 159.16 as 159

But so far I have fail .

Can any one assist

[sandy666]

maybe: = ROUND(Amount,0)

[JEAN1972]

Thank you for assistance

[MarvinP]

Hi Jean,

In your dialog box, in the Formula cell put:

"=Round(" Then click on the word "Amount" in the Fields List, which will insert it into your formula. Then type the final ",0)" to end the round function.

Hope that helps.

[sandy666]

You are welcome
Thanks for the feedback and mark thread solved