Hello guys,
is it possible to calculate with one field of two different documents?
Example:
I have two documents with the fields "jobID", "number", "jobType" and some others, which are not important.
What I want to do is a subtraction of the numbers from documents with the same jobID and two different specific typeOfJobs. So as two with "jobId = 5" and "number (of jobType = One) - number (of jobType = Two)".
Thanks in advance.