More View questions
More View questions
(OP)
In the view i need to subract the number from column 1 from Column 2
can this be done? if so how?
can this be done? if so how?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
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.
RE: More View questions
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.