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

mark_s_vangee

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!

Lasse

Hi,

Could this solve the problem?

Select Home → Options → View → Suppress zero values

-Lasse

mark_s_vangee

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.