Monarch classic : Is there a way to create an If formula to return a blank value

mark_s_vangee
mark_s_vangee Altair Community Member
in Community Q&A

Hello,

I am trying to figure out how to create an If formula to return a blank value.

This is what I'm looking for : If(condition,true value,return a blank value)

My current formula looks like this : If(condition,true value,0) I can't figure out how to return a blank value instead of plugging with a zero (0). It is a numerical field.

I hope that this makes sense.

Thanks,

MVG

p.s. - Happy Holidays to All!

Tagged:

Answers

  • Lasse
    Lasse Altair Community Member

    Hi,

    Could this solve the problem?

    Select Home → Options → View → Suppress zero values

    -Lasse

  • mark_s_vangee
    mark_s_vangee Altair Community Member

    Hello,

    Thank You Lasse for trying to help!

    Unfortunately there are times when the value in this field needs to be a zero as it is numerical data.

Categories