IIF condition returns error

[chuito7]

I have the following IIF statement:

=IIf((SUM(Fields!LBS_QTY.Value)= 0.00),0.00,Sum(Fields!XTNDPRCE.Value)/Sum(Fields!LBS_QTY.Value))

if Sum(Fields!LBS_QTY.Value) equals 0.00 which if is the result has to be 0.00, instead the statement is returning me an error. What is wrong?

Any help will be appreciated!!!

Jesus M. Cruz Narvaez
Senior IT Consultant
JT Consulting Group, Inc.
jesus@jtconsulting.com

 

[RiverGuy]

See here. Either nest two IIF statements, or make a VB function

http://social.msdn.microsoft.com/fo...s/thread/ef1a0375-414e-41f4-b32f-3b782c5b4c85