Forum Discussion
Project Online custom formatting text
Write your text field formula like this:
Text1=format([ROE]*[OV Budget Estimate (x)],"$#,#.##")
Hope this helps.
John
Hi John, Thank you so much for getting back to me.
However I could not get this formula to work. When I set up a new Enterprise Custom Field in PWA, and create the new field as a Project level, text field and go down to the formula section and paste in the formula you indicated, I get an error "The formula contains errors. Please correct the formula and try again"
I also tried simply dropping the "Text1=" part of the formula since I don't believe that's required in the initial part of the formula.
Can you advise further ? Have you tested this in PWA yourself ?
Thanks so much
Alison
That's right, the "Test1 =" is not part of the formula. Also, I assume you renamed a Number field as "ROE" and a Cost field as "OV Budget..." and not simply changed the column title. To be sure, you might try using the actual field names in the formula (e.g. NumberX and CostX) and see it that works.
Unfortunately I use Project desktop so I can't help with PWA. If you did rename the fields and removed the "Text1 =" but it still fails, then I suspect the issue has to do with how you set up the formula in the enterprise environment, and for that, I'll have to call in someone with Project Online experience.
John
Hi John,
I got it working in the end. I couldn't get this part of the formula to work properly "$#,#.##" because it resulted in a value in the form $589,000.
but when I used "$#,#.00" it resulted in the format $589,000.00 which is good enough.
Thanks so much for your help.
Best Wishes
Alison
