Open Forum

Expand all | Collapse all

Report Writer help with Calculated Field

  • 1.  Report Writer help with Calculated Field

    SILVER CONTRIBUTOR
    Posted 4 days ago
    Need a simple calculate field but don't know how to express "null" or "blank" in RW...

    Need:
    IF "Sales User-Defined Work History user defined table 1" not Null
    Then "Sales User-Defined Work History user defined Table 1"
    Else "Constant"

    I have the user defined table 1... no prob.
    I have the constant I want if the field is blank or null...

    I see "not" clearly... but how do I get the tool to accept "null" or "Blank"?

    ------------------------------
    Justin Ross
    TD Carpenter & Associates, Inc.
    Sarasota FL
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Report Writer help with Calculated Field

    SILVER CONTRIBUTOR
    Posted 4 days ago
    Hi Justin,

    You should be able to do this by selecting the Constants tab, select the String type, leave the Constant field blank and click Add.  This will enter an empty string.



    Thanks!

    ------------------------------
    Jamie Evenson
    CEO
    Najaxa Software
    Las Vegas, NV
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Report Writer help with Calculated Field

    SILVER CONTRIBUTOR
    Posted 4 days ago
    Thank you!  Once I figured out the " <>"  is way better than "NOT =" it worked great!

    Thanks!

    Now I get to post another Help!! on the template itself!   Grrr...

    Thanks again!

    Justin

    ------------------------------
    Justin Ross
    TD Carpenter & Associates, Inc.
    Sarasota FL
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Report Writer help with Calculated Field

    GPUG ALL STAR
    Posted 4 days ago
    @Justin Ross

    Glad you got this sorted.

    Just a note. Dexterity (the language behind GP) does not understand the concept of Null. It knows blank or empty records such as zero numerical values or ​empty strings.

    Where this can have an effect is if performing outer joins at the SQL level (as a developer or for a Smartlist query) you must use isnull() or coalesce () to ensure that possible null values are replaced with empty or blank values.

    Just a bit of geek knowledge for you.

    Enjoy

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role