Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Can formulas return null?

    Posted Mon December 23, 2019 09:20 AM
    In Maximo 7.6.1.1,

    I have an attribute formula on a persistent field called WORKORDER.X. The field type is decimal, length is 18, and scale is 10.

    The formula is meant to do this:

    If not null, use WOSERVICEADDRESS.LONGITUDEX
    Else, if not null, use ASSET.X
    Else, if not null, use LOCATION.X

    This is the expression I've come up with:
    NVL(SERVICEADDRESS$LongitudeX, NVL(ASSET$X, NVL(LOCATION$X,0) ) )

    Question:
    If all of the search-values end up being null, is there a way to return null, rather than 0?

    I've tried just typing the word null, but get an error:
    BMXAA9399E - This formula is invalid because the following attribute or token is
    invalid: null. Specify a valid attribute and try again.

    I've also tried "", but that returns 0.
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Can formulas return null?

    Posted Mon January 06, 2020 07:52 AM
    Edited by System Admin Wed March 22, 2023 11:44 AM
    Did you try "IF(isnull$WORKORDER.X...." instead of NVL ? You can use a condition as well. If it does not work, sometime it's easier to use an automation skip instead of a formula. Your case is easy to code in a script.

    ------------------------------
    Serge Gagnon
    STI Maintenance
    Jonquiere QC
    ------------------------------



  • 3.  RE: Can formulas return null?

    Posted Mon January 06, 2020 01:32 PM
    Edited by System Admin Wed March 22, 2023 11:45 AM
    Hi Serge. Good idea. Thanks.

    I tried IF instead of NVL, but unfortunately, I still have the same problem. I can't return null:

    IF(1=1,1,null)

    BMXAA9399E - This formula is invalid because the following attribute or token is invalid: null. Specify a valid attribute and try again.

    And returning the value of a field that is known to be null (as a workaround) produces an error too (IF(1=2,2,X)).
    Also, double-quotes returns zero, not null (not what I'm looking for). 


    ------------------------------
    Thanks
    ------------------------------



  • 4.  RE: Can formulas return null?

    Posted Sun April 19, 2020 11:51 PM
    Hi,
    I have the same issue. I also need to return "null" in a similar formula. Does anyone have a solution to this?

    ......................
    Nikolay Stoimenov
    "Dripping water hollows out stone, not through force but through persistence."
    https://nikolay100.com/


    ------------------------------
    Nikolay Stoimenov
    ------------------------------



  • 5.  RE: Can formulas return null?

    Posted Mon April 20, 2020 09:50 AM
    Edited by System Admin Wed March 22, 2023 11:49 AM


  • 6.  RE: Can formulas return null?

    Posted Tue September 14, 2021 09:31 PM
    Edited by System Admin Wed March 22, 2023 11:50 AM
    @Nikolay Stoimenov

    From testing, this is what I've found in Maximo 7.6.1.2:

    • Non-persistent fields can handle nulls without issue. I used this to return a null: NULLVALUE( ) 
    • But persistent fields can't seem to handle nulls. I tried using this to return a null: NULLVALUE( )

    Error:

    BMXAA3761E - The event has failed. Ensure that the event is registered correctly. See the log file in the APP HOME directory for more details about the error.

    null

    Word has it that this issue has been fixed in 7.6.1.3 and 8.1.

    Or maybe you're using non-persistent fields, in which case NULLVALUE( ) might help you in your current version.

    Cheers.
    #AssetandFacilitiesManagement
    #Maximo


  • 7.  RE: Can formulas return null?

    Posted Wed September 15, 2021 05:51 PM
      |   view attached

    @Nikolay Stoimenov

    Here is a Word doc that shows the testing I did (attached).


    Conclusion:

    Formulas can return null to non-persistent fields.

    But, formulas can't return null to persistent fields.


    I would love to be wrong about this though.