I have an sql data set which has a myriad of columns, however what I am trying to do is create an aggr expression whereby the GrossAmount returned is based upon the BkClaimNo, ClaimPaymentRecoveryType ='Payment' and IsCurrentTransaction='-1'
The exspression I am using is below.
I have attached a very small subset of the data for visual reference and would in the first instance like to know whether my expression is logical. Obviously I am not getting the correct answer and need to determine whether my expression is valid or not which will then determine the next step
Cheers in advance