R – conditional sum not working on certain datatypes

reportingreporting-services

I have a conditional sum in my grouping

=sum(iif(Fields!Letter.Value="Service",0,Fields!Mailed.Value))

I keep getting the #error on half the fields. There all numbers. In my proc im calling the fields that are erroring outare doing a calculation. I tried putting those into a subquery and calling and it errored out. Im not sure where to go from here.

Any ideas on why this may be and how to fix it?

Best Answer

This snippet shows a solution:

=Sum(iif(Fields!Status.value = "Value a", Cdbl(Fields!Payment.Value), 0.0))

Worked for me. Apparently you have to set the same data type in both results either true or false.

Related Solutions

SSRS: Report Builder: Conditional Formatting in a calculated Text Box

Depending on scope you can reference the textbox by using ReportItems, so if the textbox that contains your calculation had a name of "Percentage" then you could reference it in another expression as follows:

=ReportItems!Percentage.Value

If you are wanting to do conditional formatting on the textbox that contains the calculation you can also use Me.Value, though I have had odd results with this sometimes.

Additionally you could repeat the expression you are using in your calculation to provide conditional formatting, for example if you wanted to change the text color for the textbox that contains the percentage you could use the expression:

=IIF((Fields.Numerator.Value / Fields.Denominator.Value) > 0.5, "Green", "Red")

Best Answer

Related Solutions

SSRS: Report Builder: Conditional Formatting in a calculated Text Box

Related Topic