hey everyone!
Having trouble wraping my head around a formula..
i have 3 tables;
<colgroup><col><col><col><col><col><col><col><col span="6"><col><col span="6"></colgroup><tbody>
</tbody>
I would have 3 selection criteria with the ultimate goal to see the 'commission rate'
criteria 1 - Best or Great or Good
Criteria 2 - anything ranging from 1 to 7 'Years'
Criteria 3 - Quote % charged
Outcome - % commission
any idea on this one? thanks
Having trouble wraping my head around a formula..
i have 3 tables;
Best | Great | Good | |||||||||||||||||
1 Year | 3 - 6 Years | 7 Years | 1 Year | 3 - 6 Years | 7 Years | 1 Year | 3 - 6 Years | 7 Years | |||||||||||
Quote | Commission | Quote | Commission | APR | Commission | Quote | Commission | Quote | Commission | APR | Commission | Quote | Commission | Quote | Commission | APR | Commission | ||
1.00% | 3.00% | 1.00% | 4.00% | 1.00% | 5.00% | 2.00% | 3.00% | 2.00% | 4.00% | 2.00% | 5.00% | 6.50% | 3.00% | 6.50% | 4.00% | 6.50% | 5.00% | ||
1.25% | 2.70% | 1.25% | 3.60% | 1.25% | 4.45% | 2.85% | 2.70% | 2.85% | 3.60% | 2.85% | 4.45% | 7.50% | 2.70% | 7.50% | 3.60% | 7.50% | 4.45% | ||
3.00% | 2.40% | 3.00% | 3.20% | 3.00% | 3.90% | 3.00% | 2.40% | 3.00% | 3.20% | 3.00% | 3.90% | 8.50% | 2.40% | 8.50% | 3.20% | 8.50% | 3.90% | ||
3.70% | 2.10% | 3.70% | 2.75% | 3.70% | 3.35% | 3.24% | 2.10% | 3.24% | 2.75% | 3.24% | 3.35% | 8.65% | 2.10% | 8.65% | 2.75% | 8.65% | 3.35% | ||
6.00% | 1.80% | 6.00% | 2.30% | 6.00% | 2.80% | 6.00% | 1.80% | 6.00% | 2.30% | 6.00% | 2.80% | 9.00% | 1.80% | 9.00% | 2.30% | 9.00% | 2.80% | ||
6.74% | 1.50% | 6.74% | 1.85% | 6.74% | 2.25% | 6.74% | 1.50% | 6.74% | 1.85% | 6.74% | 2.25% | 10.00% | 1.50% | 10.00% | 1.85% | 10.00% | 2.25% |
<colgroup><col><col><col><col><col><col><col><col span="6"><col><col span="6"></colgroup><tbody>
</tbody>
I would have 3 selection criteria with the ultimate goal to see the 'commission rate'
criteria 1 - Best or Great or Good
Criteria 2 - anything ranging from 1 to 7 'Years'
Criteria 3 - Quote % charged
Outcome - % commission
any idea on this one? thanks