formula total 1

[dikidushi]

hi guyz, here is my problem

numbervar ;= {1.Credit Note Total} * tax 0.063830 this is ny formula, please help what am i doing wrong???
i keep getting, errors.

in 1.credit note total is some field that i cannot edit, however i know whats in the credit note total, its price * quantity.
so i created a formula that say tax. i need to tel to create a formula that state credit total * tax i subtotal. but i keep getting errors.

please help

here is all the field thats in (1.Credit Note Total)

; Field definition file for table: GenericDataProvider
Order Number string 255 string sample value
Invoice Number string 255 string sample value
Description string 255 string sample value
PO Number string 255 string sample value
Customer Number string 255 string sample value
Customer Company string 255 string sample value
Customer Name string 255 string sample value
Customer Address1 string 255 string sample value
Customer Address2 string 255 string sample value
Customer City string 255 string sample value
Customer Country string 255 string sample value
Customer Phone string 255 string sample value
Customer Fax string 255 string sample value
Order Type string 255 string sample value
Notes string 255 string sample value
Currency string 255 string sample value
Order Date string 255 string sample value
Credit Note Number string 255 string sample value
Credit Note Date string 255 string sample value
Credit By string 255 string sample value
Returned string 255 string sample value
Quantity string 255 string sample value
Unit of Measure string 255 string sample value
Price string 255 string sample value
Product Code string 255 string sample value
Product Name string 255 string sample value
Restocking Fee string 255 string sample value
Item Total string 255 string sample value
Credit Note Total string 255 string sample value
Company Name string 255 string sample value
Company Address string 255 string sample value
Company City string 255 string sample value
Company Country string 255 string sample value
Company Phone string 255 string sample value
Reprint string 255 string sample value
Copy string 255 string sample value
Company Fax string 255 string sample value

 

[lbass]

It looks like credit note total might be a string, so try this:

Tonumber({i.credit note total})*.06383

Not sure why you are using a variable. If there is a reason for it, and if what you are showing above is exactly as written, then you have an error because you are using a semicolon instead of a colon.

If this doesn’t fix the issue, you should report what the error message is. You should also copy the formula into the thread instead of typing it in.

-LB

 

[dikidushi]

wooow

http://www thanks

lbass, it worked perfectly. now i need to insert the subtotal of those two. credit total + tax = total

 

[dikidushi]

ok i figured tha last question out. its all ok now. thank u very much for your help lbass