Search code examples
reporting-servicesssrs-2008crmdynamics-crm-2013

CRM Report Miscalculating columns

I have created a custom column, in a CRM report, and the column sometimes does not calculate the answer correctly.

See Attached image: https://i.sstatic.net/l3D4J.jpg

The left column is: =CDbl(Sum(Fields!ask_totalduration.Value/60)).ToString("N1", Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureInfo(Parameters))

The Middle column is: =Fields!ask_response.Value

The right column is: =iif(Fields!ask_response.Value>Fields!ask_totalduration.Value, "Time Met", "Time not Met")

As seen in the picture, something is not working properly, but I am unable to figure it out.

Thanks Joe

Solution

  • Looks like it might be a type coercion issue.

    Try changing your formula to this: =IIf(CDbl(Fields!ask_response.Value) > CDbl(Fields!ask_totalduration.Value), "Time Met", "Time not Met")

    This will ensure no implicit conversions are being performed.