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)
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
Add photo