2

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.

7

You need to use the ISNULL() function instead of checking the Value(Object2)=null.

Change to this

ISNULL(VALUE(object2))

EDIT

As @Sdry points out, you could also use

ISBLANK(VALUE(object2))

ISBLANK() is a newer function, it has the same functionality as ISNULL, but also supports text fields. So as Sdry points out, it is highly preferred over ISNULL(). ISNULL() will still work, just not the preferable function.

3
  • 4
    IsBlank() is highly prefered over isnull() Sep 17 '13 at 11:41
  • Agreed. Edited the answer to reflect Sep 17 '13 at 11:48
  • IsBlank() makes the formula to work fine.
    – Dinesh
    Sep 17 '13 at 13:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.