var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conditional subtraction between two forms
I'm a user of Brilliant database 10.5 and have a question for everyone please.
Please i need help on how to Subtract a field's value in a form from another field value in a
different form based on a rule that if both forms each have a field that has a common
value, then the subtraction holds. e.g
if in form "A", there are two fields namely [label] having a value of DER45, and a field called
[Figures] having a value of 5600. And if in form "B", there are also two fields namely [label]
having a value of DER45, and a field called [Figures] having a value of 4500.
So what i want to achieve is to say that because both forms have a common value for their [Label]
fields, i will then subtract the value of [Figures] in form "B" from [Figures] in form "A" to give the answer in another field called [Difference] on form "B".
I will be grateful if promptly replied. Thanks a lot.
Tags for this Thread