Hello,
I have the following INLINE table with a simple expression which works correctly when I create a SET variable = "=@SurgicalNetRev" .
NetRevenueOption:
LOAD * INLINE [
@NetRevOptionNum, NetRevOption, @NetRevField, @IPNetRevField, @OPNetRevField, @GrossRevField, @IPGrossRevField, @OPGrossRevField, @NRCases, @SurgicalNetRev
1, Cash Reimbursement, ActualReimbursement, IPActualReimbursement, OPActualReimbursement, ChargesWCash, IPChargesWCash, OPChargesWCash, CashCases, SUM({$<SurgicalCases = {1}>}ActualReimbursement)
2, Standard Reimbursement, StandardReimbursement, IPStandardReimbursement, OPStandardReimbursement, GrossPatientRevenue, IPCharges, OPCharges, Cases, SUM({$<SurgicalCases = {1}>}StandardReimbursement)
3, Expected Payment, GrossReimbursement, IPGrossReimbursement, OPGrossReimbursement, ChargesWExpReimb, IPChargesWExpReimb, OPChargesWExpReimb, ExpReimbCases, SUM({$<SurgicalCases = {1}>}GrossReimbursement)
4, Cleared Payments, ClearedPayments, IPClearedPayments, OPClearedPayments, ClearedCharges, ClearedIPCharges, ClearedOPCharges, ClearedCases, SUM({$<SurgicalCases = {1}>}ClearedPayments)
];My problem comes when I want to add more than one condition in my set analysis expression. Adding a "," breaks apart the expression and my variable is set to only include the portion prior to the comma.
i.e.
SUM({$<SurgicalCases = {1}, CostedIND = {1}>}ActualReimbursement)
My set variable is SUM({$<Surgical={1}
How can I get the expression in the INLINE table to include everything including and after the comma?
