If expression for missing values in Calculated field? | Community
Skip to main content
Kundanism
Kundanism
New Participant
November 9, 2021
Solved

If expression for missing values in Calculated field?

  • November 9, 2021
  • 1 reply
  • 708 views

Hello to All,

I started to learn & work upon calculated expression, tried from my side but no success.

Goal is if SV1 is less and equal to 15, then Type A. If SV1 is more than 15, then Type B. Else, the empty field must show "Missing Value" if any of the field from VA / VB / VC / VD / VE is left blank. Then SV1 should show as "Missing value".

I tried to create expression with:

IF(SV1=0, "Missing Values",(IF(SV1>15, "Type A", IF(SV1<16, "Type B"))))

Attached overview for your kind reference.

Looking for your guidance.

Best regards,

Kundan.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

Hi Kundan,

The following expression should do it:

IF(ISBLANK(SV1),"Missing Values",IF(SV1<=15,"Type A",IF(SV1>15,"Type B")))

Couple of pointers to help you along :

  • The 'IF(ISBLANK(Field),True,False' expressionis best when you want to output something when there is no value. Your current expression is looking for a '0' which is a value and will cause your expression to fail.
  • When you are using a less than or equal to operator you need to use '<='. '<' only looks at values that are less than

Hope that helps!

Best regards,

Rich.

1 reply

R
Richard_Le_Accepted solution
New Participant
November 9, 2021

Hi Kundan,

The following expression should do it:

IF(ISBLANK(SV1),"Missing Values",IF(SV1<=15,"Type A",IF(SV1>15,"Type B")))

Couple of pointers to help you along :

  • The 'IF(ISBLANK(Field),True,False' expressionis best when you want to output something when there is no value. Your current expression is looking for a '0' which is a value and will cause your expression to fail.
  • When you are using a less than or equal to operator you need to use '<='. '<' only looks at values that are less than

Hope that helps!

Best regards,

Rich.

    Kundanism
    KundanismAuthor
    New Participant
    November 10, 2021

    Thanks a lot @Richard Leek‚ . I really appreciate your help in this regard.

    I will check and confirm you soon.

    Thank you once again.

    Have a nice day!

    Best regards,

    Kundan.

    Terms & ConditionsAccessibility statement

    Loading footer...