I have a repeating section with a value filed and what I would like to to is to calculate the total depending on the drop down menu choice
eg
Date | Choice (drop down menu) | Value |
---|---|---|
11/06/2015 | Flight | £10.00 |
11/06/2015 | Taxi | £10.00 |
11/06/2015 | Flight | £20.00 |
Choice | Total |
---|---|
Flight | £30.00 |
Taxi | £10.00 |
Grand total | £40.00 |
Is this possible?