Visokio website     Downloads     Video tutorials     KnowledgeBase  
JavaScript: NULL or null values (no value) in formula? - Visokio Forums
JavaScript: NULL or null values (no value) in formula?
  •     enrico68 September 25, 2012 8:48AM
    Hi - Using the formula wizard I tried this statement:

    SUBSET_UNIQUESLIST([Field 2], SUBSET([Field 2],NULL,'<>'))

    and it works fine, returning the list of non-empty in [Field2].

    However, when I tried it in a script defining an array:

    var array = subset_uniquesList('ABICapoGruppo', SUBSET('ABICapoGruppo',NULL,'<>'));

    it returns the message that NULL is not defined. Which is the way to express the NULL values in scripts?

    Thanks
  • 2 Comments
  •     enrico68 September 25, 2012 8:54AM
    OK! Already solved.
    It was enough to write null instead of NULL ....

    Thanks anyway.
  •     steve September 25, 2012 9:09AM
    Correct, in formulae you can write NULL irrespective of case. In scripts, it has to be "null" precisely.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged