Subtracting from one column to another in a Lotus View

90 pts.
Domino Designer
Lotus Domino
Lotus Notes 7.x
Lotus Notes View
Hi, I've created two forms. I need to display the value from FORM A to FORM B and display the difference in the 3rd Column in a View. I haven't tried subtracting values in a view. Could you please help me out. Newbie in Lotus Domino Designer.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If I understand your question correctly, you cannot do this. In the view, the records created from FormA will end up on a different row than FormB, thus you can not do any calculations on them. I might be able to help if you give more details to your issue. Why are their two forms? If the documents are different why? If this separation is necessary, can they be combined in the backend to another document with a different form for display in a view?

Mike Kinder

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • jane0323
    Well actually, I am doing a compensatory database wherein Form A is for "Compensatory Earned" and the second form is for applying when to use the compensatory. So for the view, I want to show the users their available Compensatory. I guess my approach on this issue is incorrect. What do you think is a better approach for this? Thanks again!
    90 pointsBadges:
  • SlikTool
    I wouldn't say you are doing it wrong, I was only stating that how you wanted to do it would not work as you were intending to do it. Based on your explanation I think you just need to add a calculating field and function on FORM A that, using the stuff on FORM B, calculates what you want to display in the view on the documents stored using FORM A. Makes sense? Mike Kinder
    1,870 pointsBadges:
  • tjarman
    I don't have Notes near me, so you may have to look a few things up, but this sounds like something I did before. Take a look at @DBColumn and @DbLookup. More particularly, I think you want @DBLookup. Check documentation to see if you can use this in a column formula. So long as you can map Form A to a single corresponding From B document. Say for example you take a name field and there is only one Form B document with the same value for the name field. When you do the lookup, the value you request will be returned. You can use this to do your calculation.
    90 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: