MaxTECH Maximo Technical User Group

Expand all | Collapse all

Formula for Attribute

  • 1.  Formula for Attribute

    Posted Tue January 07, 2020 06:35 AM
    I am looking for a formula to add Life Expectancy (Integer "Years") to the INSTALLDATE in the Asset table. 
    I was looking at using the Add/Modify Formula for Attribute but I don't know who to write the Formula Expression since this would be adding an Integer to a Date. Can someone show me what the Expression would be?

    I'm in a SQL environment
    These are the two attributes

    INSTALLDATE+EXPECTEDLIFE

    ------------------------------
    Duane (Woodie) Wood
    CMMS Manager
    EMCOR Government Services| Inc.
    Arlington VA
    571-403-8940
    ------------------------------


  • 2.  RE: Formula for Attribute

    Posted Tue January 07, 2020 02:49 PM
    Hello Woodie, 
    I have sent a message to some of the more technical gurus I work with to see what their answer might be.  I will post their reply once I receive it.  

    regards, 
    Stephen

    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------



  • 3.  RE: Formula for Attribute

    Posted Tue January 07, 2020 03:35 PM
    Hi Woodie, I managed to get a formula to calculate the ESTENDOFLIFE

    Object Name: ASSET
    Attribute Name: ESTENDOFLIFE
    Formula Expression: installdate + duration(expectedlife,0,0,0,0,0,0)

    I have a couple of screenshots of my test, but if you change either the install date or the expectedlife the estendoflife date is recalculated automatically. 

    Hope this works for you.


    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------



  • 4.  RE: Formula for Attribute

    Posted Tue January 07, 2020 03:39 PM


    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------



  • 5.  RE: Formula for Attribute

    Posted Tue January 07, 2020 03:40 PM
      Here is a screenshot from the asset application...


    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------



  • 6.  RE: Formula for Attribute

    Posted Wed January 08, 2020 07:08 AM
    So, in short, this works but there seems to be a "creep" factor occurring that's knocking off hours. 
    Is there anything in those "0,0,0,0,0.." that could counter this?


    ------------------------------
    Duane (Woodie) Wood
    CMMS Manager
    EMCOR Government Services| Inc.
    Arlington VA
    571-403-8940
    ------------------------------



  • 7.  RE: Formula for Attribute

    Posted Wed January 08, 2020 10:44 AM
    Woodie, I played around a bit with the formula and managed to get the date "creep" down significantly with the following formula

    installdate+duration(0,0,expectedlife*365.25,0,0,0)

    The result is an estimated end of life within 12 hours of accuracy... which for doing asset end of life estimates seems close.

    This formula is putting the expectedlife*365.25  in the days position, which has a higher accuracy than the year position.

    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------



  • 8.  RE: Formula for Attribute

    Posted Wed January 08, 2020 11:31 AM
    Yep, that is definitely working better.
    I am assuming the 0,0,0... equate to Year, Month, Hour, Minute, Second?
    Is there a list that breaks these down?

    ------------------------------
    Duane (Woodie) Wood
    CMMS Manager
    EMCOR Government Services| Inc.
    Arlington VA
    571-403-8940
    ------------------------------



  • 9.  RE: Formula for Attribute

    Posted Wed January 08, 2020 11:50 AM
      |   view attached
    I have uploaded the file that I found on the internet which documents the formulas a bit. 
    (MaximoFormula (2).pdf

    ------------------------------
    Stephen Hume
    Senior Maximo Consultant
    BPD Zenith
    403 464-5779
    ------------------------------

    Attachment(s)

    pdf
    MaximoFormula (2).pdf   204K 1 version


  • 10.  RE: Formula for Attribute

    Posted Wed January 08, 2020 12:41 PM
    Thank you very much for the help and an excellent document on formulas.
    I've added it to my repository.

    ------------------------------
    Duane (Woodie) Wood
    CMMS Manager
    EMCOR Government Services| Inc.
    Arlington VA
    571-403-8940
    ------------------------------