Set up linked record for variable costs

Topic Labels: Formulas
354 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have a base with labor rates, which can vary depending on retail / wholesale, etc … screenshot 1

Screen Shot 2022-04-08 at 3.52.06 PM

That table links to another table in the same base, which has a variety of categories. Might price category 1 at List Price, category 2 at 10% off, category 3 at cost +10%, etc … screenshot 2

Screen Shot 2022-04-08 at 3.53.29 PM

Is there a way to have one “base rate” amount, and then have the variable rates calculate based on that? Right now, I just input them each manually. Would be nice to change the “base rate” and have all the variables automatically update. I realize I could do this in multiple fields, but that won’t give me the ability to have a linked record selection?

Thanks in advance

0 Replies 0