If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculated field
Hi;
I have created an expense report template, that has a column of totals. Each total is a form field, marked as a "Number" and "Calculate on Exit". At the bottom of the column, I have a subtotal, which works fine. The next field is a form field which is also marked as "Number" and "Calculate on Exit" where users can put an amount advanced to them. The last field is the problem, it is a form field, marked as "Calculation", where I have =text25-text26, so the advance is subtracted from the subtotal, which should give a Grand total. If I enter "35.00" in one of the total fields, it will put "3535.00), so it doubles whatever number I enter. Can you help? It looks like this; Airfa 35.00 Hotel: 125.00 Subtotal: 145.00 Less Adv: 50.00 Total: 3535.00 Thanks! |
#2
|
|||
|
|||
Calculated field
In a formfield calculation, you cannot use as an input to the calculation
another formfield that is itself the result of a calculation. To get the total, you will have to use = airfare + hotel - advance -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Julie" wrote in message ... Hi; I have created an expense report template, that has a column of totals. Each total is a form field, marked as a "Number" and "Calculate on Exit". At the bottom of the column, I have a subtotal, which works fine. The next field is a form field which is also marked as "Number" and "Calculate on Exit" where users can put an amount advanced to them. The last field is the problem, it is a form field, marked as "Calculation", where I have =text25-text26, so the advance is subtracted from the subtotal, which should give a Grand total. If I enter "35.00" in one of the total fields, it will put "3535.00), so it doubles whatever number I enter. Can you help? It looks like this; Airfa 35.00 Hotel: 125.00 Subtotal: 145.00 Less Adv: 50.00 Total: 3535.00 Thanks! |
#3
|
|||
|
|||
Calculated field
Thank you so much
-----Original Message----- In a formfield calculation, you cannot use as an input to the calculation another formfield that is itself the result of a calculation. To get the total, you will have to use = airfare + hotel - advance -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Julie" wrote in message ... Hi; I have created an expense report template, that has a column of totals. Each total is a form field, marked as a "Number" and "Calculate on Exit". At the bottom of the column, I have a subtotal, which works fine. The next field is a form field which is also marked as "Number" and "Calculate on Exit" where users can put an amount advanced to them. The last field is the problem, it is a form field, marked as "Calculation", where I have =text25-text26, so the advance is subtracted from the subtotal, which should give a Grand total. If I enter "35.00" in one of the total fields, it will put "3535.00), so it doubles whatever number I enter. Can you help? It looks like this; Airfa 35.00 Hotel: 125.00 Subtotal: 145.00 Less Adv: 50.00 Total: 3535.00 Thanks! . |
Thread Tools | |
Display Modes | |
|
|