Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula creating a total for multiplying multiple columns by fixed cost

Topic Labels: Formulas
767 1
cancel
Showing results for 
Search instead for 
Did you mean: 
tarincook
4 - Data Explorer
4 - Data Explorer

Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books. 

In the form submitted, customers can select additional books for purchase at $45 for K-2nd and $60 for 3rd-6th.

I am trying to find the sum of:

multiplying the following columns by $45: Additional K English, Additional K Spanish, Additional 1st English, Additional 1st Spanish, Additional 2nd English, Additional 2nd Spanish 

multiplying the following columns by $60: Additional 3rd English, Additional 3rd Spanish, Additional 4th English, Additional 4th Spanish, Additional 5th English, Additional 5th Spanish, Additional 6th English, Additional 6th Spanish

for a total cost to appear in "Additional Books Purchased:"

 

ex: 1 additional K Spanish & 1 additional 6th English would equal $105 in the additional books purchased column. 

Any help is greatly appreciated!

 

1 Reply 1
Sho
11 - Venus
11 - Venus

Hi @tarincook,

Is the selection of books a multi-select or a linked record?
Ideally, it would be easier to manage books and calculate prices if there is a book table, with selections made by link record, and prices set for each book.
If multi-select, you would need to condition all book names with a formula.