Loading...
Quick Links

Help in formatting a custom numbers field

Home Forums Discussion Help in formatting a custom numbers field

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #5247 Reply
    CommunityCommunity
    Keymaster

    Following is my formatting problem:

    Task Mode Task Name Finish Finish1 Days
    Auto Scheduled Deployment 1.0 Tue 1/10/12 NA 4294926376.29
    Manually Scheduled Task 1 Mon 1/9/12 Tue 1/10/12 1.38
    Manually Scheduled Task 2 Tue 1/10/12 Wed 1/11/12 1

    The finish Fields are extracted from other project files. The Days field is a custom Number field that is calculated as follows:

    Finish1-Finish

    Can someone please help me in showing me how to format the “Days” column with zero decimal.

    Thanks for your help

    #6962 Reply
    CommunityCommunity
    Keymaster

    Asim,

    I took a quick look at this – one possible quick fix could be adding the integer function to your formula:

    Int(Finish1-Finish)

    It returns the integer portion of a number.  I call this a quick fix because I think there are several ways you can have a decimal in this field and you might want to investigate further.  If there is a difference in the working times between the two different projects, this might be a cause.  You can show the time along with the date to see if one finish is at 5:00 and the other is at a different time (options/general/date format).

    Regards,

    Tim Jones

    #6964 Reply
    CommunityCommunity
    Keymaster

    From memory, you can use a mixture of instr and left to find the number of characters to the left of the period (.) and then return the number of characters to the left of the (.)  this wouldn’t round it up, just truncate it.  A number field formats to 2 decimal places.

    #6972 Reply
    CommunityCommunity
    Keymaster

    Pls try DateDiff( d”, [Finish, [Finish1] ) or the following to suppress “#ERROR” in case Finish1 contains no valid date value:

    IIf([Finish1]=ProjDateValue(“NA,0,DateDiff(“d”,[Finish],[Finish1]))

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Help in formatting a custom numbers field
Your information:




− 6 = 2