Subtracting from one column to another in a Lotus 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.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 19, 2009 5:35 AM
UPDATED:
March 21, 2009 12:36 PM
RELATED QUESTIONS
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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!
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
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.