Hello Tuan,
I created a Group Membership on the site I am working on and set the prorating feature.
For context this are the settings of this plan:
- Subscription Expiry Date: December 31
- Prorated Signup Cost: by month
- Minimum number of Members: 5
- Plan Price: $ 650,00
- Additional Member Price: $ 135,00
I have created two additional fee fields to deal with the additional number of members and the calculation of the final price to paid in case there are more than 5 members. The two fields are:
- TOTAL_MEMBERS: With a minimum of 5, and the subscriber can increase this number. This field is used on the Number Members Field on the plan settings
- ADDITIONAL_TOTAL: This field does the actual calculation of how much the subscriber needs to pay according to the number of Additional Members added, and I placed the following formula on the Fee Formula field:
Code:
(([TOTAL_MEMBERS]-5)*135)-[TOTAL_MEMBERS]
I had to add the
because the number of members was being added to the final Price.
The final Price is not prorating the additional member amount. e.g.:
Creating a subscription today for 6 members the amounts had to be:
- The base price: (650/12)*10 = $ 541,67
- Additional member: (135/12)*10 = $ 112,50
- Total: $ 654,17
What is actually happening (WRONG PRICE):
- The base price: (650/12)*10 = $ 541,67
- Additional member: $ 135,00
- Total: $ 676,67 - It is considering a full year for additional members
How can I make this calculation? Are there Date codes that can be used on thee fee formula?
Thanks a lot for your help.
