Search code examples
reporting-servicesssrs-2012

expression when sum have minus number then show 0


I have textbox with expression

=Sum(Fields!servicetotal.Value, "Service") - Sum(Fields!servicefee.Value, "Service")

Got the correct result.

If the result number is negative, then I need to show (display) 0.

Can you help me? Thank you.


Solution

  • =IIF(
         Sum(Fields!servicetotal.Value, "Service") - Sum(Fields!servicefee.Value, "Service")<0,
        0,
        Sum(Fields!servicetotal.Value, "Service") - Sum(Fields!servicefee.Value, "Service")
        )