http://forums.visokio.com/discussions/tagged/null/feed.rss Mon, 30 Oct 17 19:28:47 -0400 Tagged with null - Visokio Forums en-CA http://forums.visokio.com/discussion/1038/formula-if-with-null-values-in-text-field Thu, 06 Oct 2011 12:44:50 -0400 Focus_Media 1038@/discussions
Steps to reproduce:

Create on new iok with 3 text fields: (Original, ChangedByUser, Formula)

Change field Formula and define this formula:
=IF(ChangedByUser="", Original, ChangedByUser)

If I write some text in the Original column, it should be shown in the Formula Field.

This worked fine until I installed yesterday last version.

Now, the condition (ChangedByUser="") ==> Is always False!!!

I think there are a little bit problem with Null/Empty values in a text field.

Because I didn't find a 'function' like IsNull(Value), i had to change the formula to:

=IF(("" & ChangedByUser)="", Original, ChangedByUser)

And then, it works fine... but I need to change a lot of formulas like this!

I think should be a 'function' IsNull(value) or IsEmpty(value), to avoid this problem.

Regards
]]>