×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

formula total

formula total

formula total

(OP)
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

RE: formula total

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

RE: formula total

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

RE: formula total

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close