limit decimal places when concatenating text and eqn.

[rgreen511]

I'm using the following code, but I need to limit the first string to two fixed decimal places. How can I do that?

lb/MMBtu: IIf(IsNull((([ppm]*(100-[% M])/100)/[BTU]*1000000)) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) & "E-06")

 

[Remou]

Do you want to Round or Format? There is a difference:

[tt]?round(1.345,2)
1.34
?format(1.345,"#0.00")
1.35[/tt]

 

[rgreen511]

Thanks.

I was able to do it by entering this into the Format box in the column properties:

0.00"E-6"

and using only the

lb/MMBtu: (([ppm]*(100-[% M])/100)/[BTU]*1000000)