question

natongm avatar image
natongm asked

Convert Crystal Reports Formula in SSRS

If (sum({command.casecount), {command.courtType}) = 0) Then 0

Else

Sum({Command.CaseDayCount}, {Command.CourtType}) / Sum({Command.CaseCount}, {Command.CourtType}) * 100

crystal reports-formula-to-ssrs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
natongm avatar image
natongm answered

I did the following and it worked:

=Switch(Sum(Fields!NewCaseCount.Value, "TimelinessNew")=0,1,

1=1,Sum(Fields!CaseWithinBusinessDayCount.Value, "TimelinessNew")/

Sum(Fields!NewCaseCount.Value, "TimelinessNew"), Fields!CourtType.Value, "TimelinessNew") * 100

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.