# Need calculation help

Asked on March 13, 2019 at 10:59 PM

Hi

I am looking to calculate when a member joins a member the club.

Example:

If a user joins in the month of November and the the membership ends on May 31. I want to use a prorate feature that charges \$10 per a month and adds 25 on the initial date of joining.

I was advised to use this

https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

I need your minds on this one.

• jherwin
Answered on March 13, 2019 at 11:25 PM

Is the month has a dropdown option or it should be selected on datepicker? Please further explain your requirements so we can make a workaround and demo form for you.

If the month is based on the date that the user chooses with datepicker then I'm afraid we need to calculate it by days to determine how many months is the membership.

Answered on March 20, 2019 at 05:12 PM

The date is when the user opens the form and choose prorated

The end date is May 31.

Calculation is

If a person is looking to join in Nov then the calculation should be any amount per a month until May 31st.

• jherwin
Answered on March 20, 2019 at 06:54 PM

I see. So the end date is fixed May 31st.

Could you please check this demo form: https://form.jotform.com/90787314577974.

I calculate the days between the current date and end date then divide it to 30 to get the number of months. I cannot find a function that gives the number of Days of a Month so you will need to either assume a fixed 30/31 days and calculate.

Could you please explain the calculation (formula) to us?

Answered on April 09, 2019 at 12:50 AM

Ok I am trying something new with the calculations.  Still the same issue, but just a new way of calculating.  I am using the localized calendar and right now the dates I am picking to make sure the form is calculating properly. I am not getting the numbers below when I change the dates. I need help?

https://form.jotform.com/90978502195163

 June July August September 116 October 106 November 96 December 86 January 76 February 66 March 56 April 46 May 36
• Victoria_K
Answered on April 09, 2019 at 03:34 AM

Hello,

Firstly, I would suggest to combine conditions using 'ALL' rule. Also, Date is not equal to any month particularly, please try checking if Date 'contains' every month value instead of 'is equal'. Here is a sample condition:

• Kiran
Answered on April 09, 2019 at 10:03 AM

@tim.nollan25,

If you are experiencing any issue with your forms, we request you to open a new thread and provide us with the form ID/URL so that one of our support team members can assist you.

Thanks!

Answered on April 10, 2019 at 07:30 PM

Still looking for help

• jherwin
Answered on April 10, 2019 at 08:43 PM

Give me more time to check this. I will update you via this thread.

• jherwin
Answered on April 11, 2019 at 10:56 AM

Sorry for delayed response. I checked the calculation and the months that did not work as expected is these:

June
July
August
September
October
November

Please check your calculation condition, those months did not show expected results because the calculation was incomplete.

Answered on April 15, 2019 at 09:58 PM

It works now.

Now I want to use this form to feed to another form using only the localized date and total.

In other words I don't want the months that are hiding to show on a report or google spreadsheet. I want it hidden.

• BDAVID
Answered on April 15, 2019 at 10:59 PM