


I posted my question under a previous post, but am afraid it will be overlooked, so i'm posting it again in hopes of getting some much needed help.
I’m trying to apply a calculation to a numeric object. My calculations are dependent on:
1. If a checkbox is checked
2. The number of days entered
3. The number of rows that are added (i'm using a repeatable subform)
Basically, if the first row is the ONLY row, then it can contain three possible calculations
However, if more than one row is selected, then the first and the last row would contain the following possible calculations:
The middle rows are always going to contain one possible calculation of…perDiem.rawValue * Days.rawValue
I have NO idea how to setup my script... i'm assuming that i need to create multiple variable (first row and last row), but have failed so far.
Views
Replies
Total Likes
Can you please share your form? It's hard to determine how your form is designed and I don't have the time to rebuild it by myself.
Views
Replies
Sign in to like this content
Total Likes
Sure, I can share it, but i'm not sure how. I dont see an option to upload a file to this message. Please let me know how to share and I'll do so. Thanks for your help!
Views
Replies
Total Likes
Use a file sharing service in the web such as Acrobat.com.
Views
Replies
Sign in to like this content
Total Likes
Thanks! I just uploaded it to https://acrobat.com/#d=PwnUtMIB5OwKlPRnagr*UA
The object that I'm referring to is located at MIEexpSection.MIEexp.gsaTotal.
MIEexp is a repeatable subform.
Please let me know if you need anything else.
Views
Replies
Total Likes
You forgot to share the form, I cannot download it.
Views
Replies
Sign in to like this content
Total Likes
sorry about that.
Try accessing it now: https://acrobat.com/#d=PwnUtMIB5OwKlPRnagr*UA
Views
Replies
Total Likes
In what field the calculated result should be shown?
Views
Replies
Sign in to like this content
Total Likes
It should be shown in the gsaTotal field.
Views
Replies
Total Likes
Ok, so far I could follow your instruction the formula (FormCalc) for the field gsaTotal look like:
Views
Replies
Sign in to like this content
Total Likes
it's perfect!!! almost..
the last row displays a negative number, until a value is entered into the Days field. How can I avoid displaying the negative number? I assume I need to add an "If Days gt 0" somewhere in the code, but am not sure where. Can you please help?
Views
Replies
Total Likes
Ok, try
Views
Replies
Sign in to like this content
Total Likes
Perfect!!!! thank you so much for your help!
Views
Replies
Total Likes