need correct usage of switch in SumIf

[ddsmith99301]

I don't understand why I am getting an error ') expected' when I try to replace the 'QueryResults.Invoice_Transaction_Broker_Commission_Amount' with 'Switch(QueryResults.Invoice_Transaction_Broker_Commission_Amount = DBNull.Value, 0, QueryResults.Invoice_Transaction_Broker_Commission_Amount != DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount)' in the following expression.


{SumIf(DataBand1,QueryResults.Invoice_Transaction_Broker_Commission_Amount,QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium"
AND QueryResults.Invoice_Production_Reporting_Date>= VI2
AND QueryResults.Invoice_Production_Reporting_Date<=VI3)}

{SumIf(DataBand1,Switch(QueryResults.Invoice_Transaction_Broker_Commission_Amount = DBNull.Value, 0, QueryResults.Invoice_Transaction_Broker_Commission_Amount != DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount), QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium"
AND QueryResults.Invoice_Production_Reporting_Date>= VI2
AND QueryResults.Invoice_Production_Reporting_Date<=VI3)}

[Lech Kulikowski]

Hello,

Please send us your report for analysis.

Thank you.

[ddsmith99301]

Can you evaluate the report without data? I can't give you the data because it is proprietary.

[ddsmith99301]

Please see the attached. Is this enough to evaluate?

[Lech Kulikowski]

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

[Lech Kulikowski]

Hello,

Please check the following expression:
{SumIf(DataBand1,Switch(QueryResults("Invoice_Transaction_Broker_Commission_Amount") = DBNull.Value, 0,
QueryResults("Invoice_Transaction_Broker_Commission_Amount") <> DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount),
QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium" AND QueryResults.Invoice_Production_Reporting_Date >= VI2 AND QueryResults.Invoice_Production_Reporting_Date <= VI3)}

Thank you.