Basically, I want to check if the value of field F1 is not empty. If the row not empty then I want to calculate F2 * F3
The following expression always print
#Error
=IIf(Fields!f1 ="" ,"" ,Fields!f2.Value* Fields!If3.Value)
Please help
views:
21answers:
1
A:
=IIF(ISNOTHING(Fields!f2.Value)," ", (IIF(ISNOTHING(Fields!If3.Value),"",
Fields!f2.Value* Fields!If3.Value))
Pranay Rana
2010-06-21 18:00:04
I tried this too, but it always shows #Error
ahmed
2010-06-21 18:03:29
is f2 and f3 field has value
Pranay Rana
2010-06-21 18:04:48
check f2 and f3 both are number type
Pranay Rana
2010-06-21 18:08:23
Some times F2 dose not have any value. Therefore it print #Error. I thought that =IIf(Fields!f1 ="" ,"" ,Fields!f2.Value* Fields!If3.Value)will only exeute the calculation if the condition is true. However, its not working
ahmed
2010-06-21 18:12:49
I also tried this =IIF(ISNOTHING(Fields!f2.Value)," ", Fields!f2.Value* Fields!If3.Value)
ahmed
2010-06-21 18:15:52
CHECK THE UPDATED ANSWER
Pranay Rana
2010-06-21 18:23:36