Community

I would like to be multiply the number of rental days (on the "Rental Period" field) by the daily cost of the protection gear. Example: If the client chooses to rent a bike for 2 days and he also wants to rent boots, his final bill should be: (85€ * RentalPeriod)+ (5€ * RentalPeriod) = 170 + 10 = 180€

Comments (1)

Vipin

May 31, 2024

Hi Diogo, you can use the TOTAL() formula to calculate the daily cost for the items selected such as rent a bike, rent boots etc. To calculate the total amount, you can multiply the daily cost with the rental period using the formula TOTAL() * Rental Period Note: You must type @ and select the Rental Period field from the list when adding the formula in the Calculate option for the Amount field.

Add your comment