Click here to Skip to main content
15,118,001 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi ,

I am using below formula in a textbox in RDLC with IIF.

=iif(Fields!Qty_3.Value="",0, 1)

Getting Perfect out put=0

but when i a trying the actual requirment i am getting #Error.

=iif(Fields!Qty_3.Value="",0, Fields!Qty_3.Value * Fields!Price_3.Value)

Geting #Error

Please Help.

Thanks ....


What I have tried:

I am using below formula in a textbox in RDLC with IIF.

=iif(Fields!Qty_3.Value="",0, 1)

Getting Perfect out put=0

but when i a trying the actual requirment i am getting #Error.

=iif(Fields!Qty_3.Value="",0, Fields!Qty_3.Value * Fields!Price_3.Value)

Geting #Error
Posted
Comments
san2debug 24-Sep-17 1:58am
   
can you explain the error details and description clearly
an0ther1 25-Sep-17 20:08pm
   
A guess would be the data types. What datatype is the Value field? If it is text there is your issue, if not what is the error you are getting?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900