The following formula keep giving syntax error. Can somebody with more experience writing the formula for infragistic take a look and fix it for me.
if([ UnitPrice ]<>NULL,if([ UnitQuantity ]<> Null,[ UnitPrice ]*[ UnitQuantity ],0.00 ),0.00)
I try removing adding parentesis but keep telling expeting "(" , There some tool in infragistic that do that for me ? Maybe I got the Tool and I dont know it.
if(ISNULL([ UnitPrice ]),0.00,if(ISNULL([ UnitQuantity ]),0.00,[ UnitPrice ]*[ UnitQuantity ]))
after several try I found one that did not get a syntax error but still get the same error problem with the null value involve in the calculation that return system errors. SO ISNULL did not stop to get the error. Any Idea how to resolve this problem.
Hi Gregorio,
I'm a little confused. What is the error you are getting with this formula?
IsNull checks for a value of Null (or Nothing in VB). It will not be true if the value is 0 or an error. For those, you would need to check if the value equals 0 or use the IsError function.