[SOLVED] Multi-user subscription calculated using CB Promotions + based upon criteria in fields

I think we need some help -

two formulas needed that add markup to subscription base price -

1. £185 base price if quantity 1 in cb field cb_mempartners but £98 if more than 1 in cb field cb_mempartners up to max £3500
2. £185 times by quantity in cb_mempartners up to max £3500

Please can you review the formulas above and reply again asap?

Thanks so much!

Please understand we can't keep providing you with custom queries; this is outside the scope of support. If you should need any further queries please contact a developer that is experienced with SQL to write them for you. The queries as follows will output the results you're wanting.

Positive Value Returned:
Negative Value Returned:
Simply place in a query field then review a profile to ensure the output is correct. You'd then apply this field as a promotion to adjust the price. Note use the negative or positive return depending on how you intend to use it (negative return should increase the price).

Edit: Forgot to add the maximum amount check.

You are fabulous xx

Hiya

Ive set this up but it isnt working - please can you review for me? I'll PM you login

Thanks Jodee

Please review my message regarding this in my previous post. If you need us to configure something for you then you need to review our by the hour services on the Membership tab of your profile. We only review as included with support in cases of bugs.

Hiya
I don't need custom help or bug fixing I just don't know how to work your system cos the manual isn't comprehensive. Please can you review these steps and let me know where I'm going wrong?
1. cb_maxsubs - integer field not visible to user with default value 3500
2. cb_noofpartners - integer field for user to enter number into during registration
3. cb_cityinvoice and cb_countryinvoice - query field with your code in (city is £185 times by cb_noofpartners field value and country is £185 if cb_noofpartners is 1 or £98 if cb_noofpartners is more than one - both codes are set to max 3500 which is the value in cb_maxsubs field. These two query fields are set to show as read only but they don't appear where they should.
4. Two promotions set up relying on fixed field value of cb_cityinvoice or cb_countryinvoice applied to the four subscriptions (city chambers, country chambers, city partnership and country partnership
Test either and they just show £185 in end confirmation screen rather than the calculation.
Please can you review for me? I've PMd login info
Thanks Jodee