sql server reporting services: I have an expression that looks like
this;"=Fields!Quantity.Value-Fields!QuantityAvailable.Value-Fields!QTYONORD.Value"

The field returns fine, but I want negative values to be returned as 0 when
the value is <=0.

Any ideas on how to do this? Would I add a IIF to the expression? Any help
is appreciated.
Thanks!

On May 24, 1:19 pm, Ryan Mcbee <RyanMc...@discussions.microsoft.com>
[quoted text, click to view]


This should work.
=iif(Fields!Quantity.Value-Fields!QuantityAvailable.Value-Fields!
QTYONORD.Value <= 0, 0, Fields!Quantity.Value-Fields!
QuantityAvailable.Value-Fields!QTYONORD.Value)

Regards,

Enrique Martinez
Sr. Software Consultant