Forum Discussion
Project Online custom formatting text
Hi everyone, I have an issue in that I need to display a custom text field as if it were a number. To give some background we have a global currency set to GBP in our Project Online environment. ...
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
Sorry, I should have shown the format expression as:
"$#,0.00"
That insures there will always be two decimal digits
John
Hi John,
Actually after a bit of playing I did get it to work, sort of....
Project Online requires a specific reference to the named custom fields so that's what I have in the formula (doesn't work quite the same way as Project Desktop in that sense).
So now the format of the resulting value shows as $546,000. instead of $546,000.00 - Any other thoughts ?
Thanks
Alison
