How to set up calculations based on a Matrix field inputs

The date fields for columns would be dollar value with total across with a final column to the right that would add line totals.

 

Also from on the Personal Car field in Travel and Expense I need a formula that calculates the mileage entered from Travel information x0.575

Hi,

I checked your most recent form and it looks like you are still using Matrices rather than the Spreadsheet widget:

http://widgets.jotform.com/widget/spreadsheet

I believe my colleague explained the setup of the widget in your previous thread.

Sorry but I don’t understand the google spreadsheet. This seem cumbersome.
...

Alternatively, you might try conditional calculations with 'UPDATE / CALCULATE FIELD’S VALUE' conditional logic rules on form.

Here is an example for one Matrix row.

Note, that you will need to set calculation condition for each row.

Can you assist me with this please.
...

1. Edit your form

2. Click "Conditions" in the toolbar

 

3. Setup your conditions:

a. Set your Rule and click the "Add Field" button:

b. Select the Matrix field. For example, the travel expenses matrix:

c. Click "Show Headers" and select the options in a row that you would like to calculate except the Totals column then click "Insert" button:

 

d.  Add + after each option. For example:

 

d. Select the Output To Field. In this example, I have selected the same matrix which is the "Trave Expenses". You have to select the last option in the row which is the total column:

 

That's it. Repeat the same for the other matrices.

Thanks