Contact US

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!

*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

More View questions

More View questions

More View questions

In the view i need to subract the number from column 1 from Column 2

can this be done? if so how?

RE: More View questions

There is one thing that is useful to keep in mind when creating views : the less work the view design has to do, the faster it will display and update.
In other words, if you have results to display in a view, and those results are rather process-intensive, it is better to put a hidden field on the form and do the calculations there, then just display the field value (the result) in the view.
That being said, view column formulas do not have any means of taking into account results from another column. There had been talk about such functionality for R6, but in the end that got removed, or was never brought to beta. You can play will column values in LScript, but you do not have access to that in column formulas.
So, if you must do the calculation in the view, you will have to repeat the formula for the first column in the second one, and work from there.

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