It's not clear to me how you've set up the fields in the Mileage field. Can you show the scripts you're using?
Why is the Total field for the Other column showing $ 1.00 when the values above it seem to be blank?
If that calculation is attached to the MileageRow1 field, that's not a good way to go about this. It would make sense to add a new column to the right of the mileage column with fields that calculates the total cost (mileage * 0.24), but you shouldn't set up a field to calculate based on the value that's entered into itself. Calculated field should normally be set to read-only to the user doesn't attempt to interact with them.
I have no formulas in the mileage kms column (except totals row) and would like the mileage $ amount column to multiply the number from the kms row *0.24. The old formula that I was using doesn't work now.
Thanks in advance!