Calculating one field from different documents

Hello guys,

is it possible to calculate with one field of two different documents? :woman_shrugging:t2:

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. :slight_smile:

See this question on deriving values from multiple docs based on a common ID: How to search relationship between log lines

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.