Zero fill field

[Marcie]

I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?

 

[Duane Hookom]

Try multiply Total times 100.
FormattedTotal: Format([Total] * 100,"000000000")

 

[Jerry Whittle]

FormattedTotal: Format([Total] * 100,"000000000")

It's the decimal point that's messing you up. Multiplying by 100 bumps
things past the decimal.

 

[Marshall Barton]

I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?

Try using:

FormattedTotal: Format([Total] * 100, "000000000")

 

[John W. Vinson]

I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?

Sounds like you need to multiply 15192.3 by 100 to get 1519230, and then
format that value.