Formula and number format in PWA 2010 RRS feed

  • Question

  • Hello,

    I'm trying to convert the hours of work into days of work in the Project Center view. I use the formula:

    Format([Work] / (8 * 60), "# ##0.00")

    The result (value) is right, but the Project Center does not obey the format I asked. It leaves the raw number format. Is there another way to display a specific number format in PWA 2010?



    Thursday, October 6, 2011 11:02 AM

All replies

  • 1) If you divide by the field [Minutes Per Day], you'll get the same results,
    but it might be a bit simpler.
    2) You'll have to drop it into a text field to control the formatting - or
    add rounding in a number field, but note the round command in Project isn't
    quite like in Excel.  I can't recall the exact difference, but I think it
    only rounds up?

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky
    Thursday, October 6, 2011 1:29 PM