Looking for How to Add an Expression to a Composite Query to Sum Number Fields
We are on PS 9.2 Image 19, PT 8.57 and I am trying to add an expression in a COMPOSITE query that will sum 3 expressions (2 from the parent query and 1 from the child query) and include the expression as a field in my results. I've tried creating the expression using the examples shown below with no success.
My goal is to add these three expression fields together:
Q1.EXPR2_2:16 is a sum from the deduction arrears, arrears balance
Q1.EXPR1_1:17 is a difference of a general deduction goal amount less goal balance
Q2.EXPR24_24:18 is the sum of pay other earnings
Expression Properties:
0