#1
|
|||
|
|||
Word Document Invoice, and Field codes are doubling fees
Good Day, New to this forum anyhow, and can't find anything specific.
Please note, I can only work with what I have so solutions have to be specific I cannot or won't be inserting a table to do what I need, this needs to happen from what I currently have. 2 Part Question, hopefully a simple fix. Word Invoice Doc I will upload a copy to view So using Legacy forms portion of the Developer Tab Placing Boxes for monetary fees Also additional fees, which for now are working (Example (Brkers input is a number, and that is multiplied by 200.00 for the total of 400) Properties is input number times 75.00 for that total (working) Hourly is input number times 400. for that total (working) Subtotal is taking the amounts and multiplying them by the input number and adding that extra to the sub total Example, 2 brokers at 200.00 is 400 but the result is being shown as 1800 not 1400 Need to have Sub total add up the above boxes before calculating tax. 2nd part of Question GST/HST Tax is a drop down box of 5%, 13%, or 15%, I would like to multiply the chosen tax rate against the Sub Total and placed into Total Piece of Cake right? Any assistance would be great, appreciate it. |
#2
|
||||
|
||||
Your Sub Total uses a calculating formfield to calculate the results of other calculating formfields. You can't use them that way because of a long-term formfield bug. What you can use is a standard formula field coded as:
{=FeeTotal+RushTotal+BrokerTotal+PropertyTotal+Hou rlyTotal \# "$,0.00"} Other changes necessarily follow from this. See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for the formula, and not quite understanding where this would be placed, or how that would work with multiple chosen numbers under Brokers/Properties/Hourly
I'm not able to edit to be able to view the formulas in the copy you provided... I am assuming that the Sub Total line would have that formula, then the \# would be the number of one of the Brokers/Properties/Hourly Not sure how this would work if all three of those boxes were filled with number, because each line is using a different multiplication factor or is the \# referring to something else? Thanks, also can we keep the form as editable so I can at least see and place the formulas on the copy that I have?....Thanks |
#4
|
||||
|
||||
The required formula is already in the document itself. All you need do with the attachment (which I've updated) is input the values in the relevant Fees, Rush, Brokers, Properties, and Hourly cells.
In order for the formfield calculations to work, Word's 'filling in forms' protection has to be applied. You can apply/remove it via Developer|Restrict Editing. Naturally, you'll need to unprotect the document so you can add formfields for the Client name, etc., before re-applying the protection.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2016 cannot hide field codes in document created by work 2013 | twinclouds | Word | 2 | 03-10-2017 03:15 PM |
The use of IF field codes in Word 2010 | sunaina_ssl@yahoo.com.au | Word | 3 | 12-01-2015 08:54 PM |
Using DocProperty Field Codes multiple times in the same document | trueimage | Word | 2 | 09-18-2013 04:44 PM |
Word Equation field codes | mkarthic | Word | 1 | 12-02-2011 02:09 AM |