I have created a formula field to calculate a score from other two fields. If the condition succeeds, the score will be a static value else the field value. The condition is
IF (AND (ISPICKVAL (object1,"object value"), VALUE (object2)=null), static value, VALUE (object2))
But the condition always fails even the scenario is correct. Is there any mistake in writing this formula? [Note: There is no syntax error when I hit "Check Syntax"]
Thanks in Advance.