We have a client with variable membership pricing and need to know how to use CBSubs to updated the Subscription Plan pricing based on other CB fields at registration.

e.g.
Base CBSubs Plan price is $55.00
Client enters a $ value in a field called GVP, e.g. $150,000.00
Another field calculates the GVP field x 0.035%
Then this total amount (from these two fields) is added to the CBSubs Subscription Plan base pricing.

Is this possible with CB and CBubs?

OK, I have installed the Promotions Plugin (and the Tax Plugin) and can't get the Promotions plugin to work when the promotion is "A fixed amount from a CB field" and the Promotions plugin setting for "CB Field containing amount" is set to a Query field that has (cb_gvp x cb_035) as the query. I have also tried cb_gvp x 0.035% as the Query that also doesn't work.

The Promotions Plugin does work with simple settings, but I can't get it to work with Query fields and selecting A fixed amount from a CB field.

I have attached a few screen shots of the CB fields and Promotions plugin setting.

Can you please help resolve this issue?

Thanks, I tried that, but now getting the following error:

500 - JDatabaseMySQLi::query: 1054 - Unknown column 'cb_035' in 'field list' SQL=SELECT ( `cb_gvp` * `cb_035` ) FROM

`j25_comprofiler` WHERE `id` = '341'

Looks like this won't work as cb_035 is a Query field.

All we need to do is multiply cb_gvp by 0.035% and add this calculated amount to the Cart as attached.

Is there another query that I can use for this or another method that works?