Some reason the Math in the equation not calculating correctly

I know it missing ) just not sure where to put them. I also get an error that says:

The Value expression for the textrun ‘Textbox126.Paragraphs[0].TextRuns[0]’ has a scope parameter that...

I can't use expressions because PTO, Payroll, and OT are not fields in my dataset they are values in the Field name strCategories.

I was able to resolve my issue.

I was able to solve the issue by adding  "*SUM(CASE WHEN decInsuranceShare IS NOT NULL THEN 1-decInsuranceShare ELSE 0.60 END)"

My question how to add that expression to my query.

ISNULL(SUM(ROUND(mnyInsurance,2)*CASE WHEN decInsuranceShare IS NOT NULL THEN 1-decInsuranceShare ELSE 0.60 END),0) Insurance

i get an error that why i was asking help.

I was able to resolve the issue i just deleted the date filter in the where clause.

Even if I do that I still get the percentage value too high it 91% when the percent suppose to be 4.5%

I was able to fixthe error if anyone else has the issue. I had ti put CINT infront of the called fields.

=SUM(IIF(Fields!strType.Value="CreditsAndDeposits",CInt(Fields!intDT.Value),CInt(0))) 

+
SUM(IIF(Fields!strType.Value="Refunds", CInt(Fields!intDT.Value),CInt(0))) 
-
SUM(IIF(Fields!strType.Value="Rent Tax",CInt(Fields!intDT.Value),CInt(0)))


-
SUM(IIF(Fields!strType.Value="Sales Tax",CInt(Fields!intDT.Value),CInt(0)))


-
SUM(IIF(Fields!strType.Value="Cost...

Thank you for the good eye but that did not fix the error.