Hi, I am trying to create a calculation field that helps calculate the total for a renovation for a home depending on a selection of both A. Major Repairs Needed and B. Condition of the Property.
The user selection from a list, multiple choice option, to select the repairs needed for the home. Each Repair has it's own prices, i.e, HVAC = $2000, Roofing = $4000, Foundation = $8000, etc.
Then the user will select a single choice option of the condition of the property. Each condition has a calculation of Lite Repair = $10 * sqft, Medium Repair = $20 * sqft, Heavy = $30 * sqft.
I want a final calculation based on the choices in A and the choice in B. Would anyone be able to help formulate this?
Please sign in to leave a comment.