Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

How to Eliminate Decimal place using Elapseddays function

  • 1.  How to Eliminate Decimal place using Elapseddays function

    Posted Nov 30, 2018 06:51 AM

    Hi Team,

     

    currently am using the below formula

     

    elapseddays(date1, date2)

     

    Result is appearing as below 10.04 . I want to remove .04  how can I show display 10 only without decimal.

     

    I tried below

     round(elapseddays(date1, date2),0) result is appearing as below 10.0

     

    Is it possible to display the days without decimal?



  • 2.  Re: How to Eliminate Decimal place using Elapseddays function
    Best Answer

    Broadcom Employee
    Posted Dec 03, 2018 03:30 PM

    In studio, for the Classic View, set your decimal display to zero or no decimal positions. 

    In the modern UI, there is a settings option to set display to 0.00, 0.0, or 0