since ‎05-11-2015
‎10-12-2019
Level 1
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
Thank you so much! I got it to work! As far as the percentage goes, I didn't quite understand what you were saying. you said "and when you enter the field" twice which is where I am having troubles understanding.

Views

121

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
Thank you for your quick replies. Here is the equation I came up with: Days Remaining=Days Allowed + (Block Start Date - Block End Date - 1) + CCTLR Ext. Days + Stop DaysNote: in this case, CCTLR Ext Days and Stop Days are going to be fields "NumericField35" and "NumericField47" respectively.Thank you.

Views

114

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
I am very sorry... you are correct! The "Day(s) Remaining" field should read 7 instead of "11" because "dec 8" and "dec 9" are considered to be used days and the "CCTLR Ext Days" gives the individual an additional day which, in turn, adds to the "days remaining" field. Now, if the field "CCTLR Ext. Day(s)" was valued at "0", then the "Day(s) Remaining" field should calculate to be "8" instead of "10" because the two fields you were referring to "NumericField35" and "NumericField47" added to the ...

Views

97

Likes

0

Replies

0
Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
The problem I am having remains in the "Days Remaining" column. If you are allowed 10 days in Block 1 and your "Block Start date" is "Dec 8, 2015" and your "Block/Eval End Date" is "Dec 9th, 2015" and you have "1" "CCTLR Ext. Day(s)".... the "Days Remaining" column should read "7" instead of "2" because the individual has used Dec 8 and Dec 9th and was allotted "1" extension day...It should read "8" instead of "7" if the 1 extension day wasn’t granted. I hope this makes sense. I have attached a ...

Views

374

Likes

0

Replies

7
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
Yes sir. It has been sent.

Views

165

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
I clicked "right answer" but I am still having issues.

Views

149

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
This the problem I am still having.

Views

150

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
it also gives me a syntax error for this line: " xfa.host.messageBox("The second date is earlier then the first date.\u000aThe date fields will reset.", "Information", 3, 1) " saying there is an error for "xfa"

Views

151

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
When you say "same as above" do you mean I can just leave the previous equation I entered and not change anything as far as the field and coding? Also, when I input the new equation you gave me in numeric field called "Days Remaining" it gives me a syntax error for this line: "if (Date2Num(DateField19, "YYYY-MM-DD") < Date2Num(DateField3, "YYYY-MM-DD")) then" saying "syntax error near token "lt""

Views

150

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
Awesome! I tried it and everything worked perfect! I have another equation that I need help with that is very similar to the previous one... I want to take a "Days Allowed" - (End Date - Start Date)= "Days Remaining" (I need it to be an integer, not a date). Thank you so much for your help!

Views

150

Likes

0

Replies

0
Re: Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891
The problem I am having is that I want the "Start Date" field and the "+1" "+2" "+3" etc. fields to be input at random. Each one of the integer fields would be a separate field that the user would enter a number into and it may not be the same number every time. It may be 1 or it may be 28. How do I get the form to auto calculate the "start date" plus the two other fields that are changed by the user (ie. "stop days" and "extension days") to get an "Estimated Completion Date"?

Views

150

Likes

0

Replies

0
Calculation Problem

christianw19891

Total Posts

12

Likes

0

0
christianw19891