Managing Layouts and Tables
I am trying to subtract values (end odometer - start odometer) from two separate layouts in order to calculate total km driven.
I tried separate tables but couldn't get the calculation to return the correct value and am not sure whether I need to refer to a row number or if there is more I need to do, like develop a relationship...
I now have one table with two layouts (see screenshot) but each layout entry appears on alternate rows of the table, again, making the calculations difficult. I also want to calculate the total time (end time - start time) so just subtracting the totals at the bottom of the table wont do..!
Can I make each layout enter data onto the same row of the table?