Form formula output


#1

I converted a simple Panorama 6 database that tracks gas mileage. The level 1 Summary record field “Mileage” contains total mileage. Level 1 Summary field “Gallons” contains gallons since mile 19834. This formula is used in the Mileage form:

{(Mileage-19834)/(Gallons)} MPG
{(Mileage-19834)} miles

Right now it displays as:

38.55717923685258 MPG
37322 miles

How do I get Panorama X to display as:

38.6 MPG
37,322 miles


#2
{pattern((Mileage-19834)/Gallons,"#.#")} MPG
{pattern(Mileage-19834,"#,")} miles

#3

:grinning:Thanks!