Formatting cents

I am using RS 2000 and I am trying to format a total amount. I want the
total amount to be separted into two separate text boxes, one with dollars
and one with cents. I am able to get the dollars portion but unable to get
the cents portion.
For example: If I have 123.05 I want 123 in box A and 05 in box B. The
problem I have is that instead of 05 I get 5.
This is the expression I am currently using and not getting what I want :
= Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
Any help would be greatly appreciated.
Scott BennettsTry this way
= (Fields!Amount.Value) - INT(Fields!Amount.Value)
Amarnath
"Scott" wrote:
> I am using RS 2000 and I am trying to format a total amount. I want the
> total amount to be separted into two separate text boxes, one with dollars
> and one with cents. I am able to get the dollars portion but unable to get
> the cents portion.
> For example: If I have 123.05 I want 123 in box A and 05 in box B. The
> problem I have is that instead of 05 I get 5.
> This is the expression I am currently using and not getting what I want :
> = Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
> Any help would be greatly appreciated.
> Scott Bennetts