Blank value ignored if formula is used

#1

Hi there

First of all, thx for this great product.

I’m trying to fill a field using a formula that makes reference to another field. This is working fine but I need that this calculated field is blank for about 50%.

It seems that whenever a formula is used, the blank value is not used.

Is this intended and I should make the formula to return the 50% of blank values?

Thanks :slight_smile:

#2

Looks like you found a bug. Inline formulas execute after the null/not null decision, which is not intended. I’ll see if I can fix that tonight. Thank you for letting me know! In the meantime you could add something like following to your formula:

if this.nil?
    nil
else
   # formula goes here
end
#3

Thanks for the fast answer :slight_smile:

I’ll try the formula.