Hello Team,
I am trying to create a new view with expression rule or sql script that will include the sum(PaymentAmt) for cases where directDepositTF is 1. For example in the attached image, caseId 138465, I would like a view that sums the amount in paymentAmt column into a new view. Thanks
Discussion posts and replies are publicly visible
For a view you could use this.
SELECT `caseId`, SUM(`paymentAmt`) FROM `TABLE_NAME` WHERE `directDepositTF` = 1 GROUP BY `caseId`;
Thank you ajhick I will try this and let you know.