Joaquin,That is exactly what I was looking for...thanks so muchWould you be able to just show me how I can display the % sign in my results? it currently just shows the number.

Hello,I am trying to figure out how to add a percentage complete column at the project level based on Actual Project Hours versus Planned Project Hours.This would be different than the regular built-in percentage complete, which doesn't work for us based on the way we set up our projects.For example...

this worked!! thanks so much, I appreciate your time.

thanks James...this didn't work either...it just returned zero on every line.

Hi Sheri,Thanks for looking at this, it is a project report. Here is what I get when I try:Thanks

thanks Sheri, but that unfortunately didn't work, and it removed all values, so the column is now blank. I'm looking for it to appear as 00.0 instead of 00.0 Hours Any ideas?

Hi everyone, Could someone help me with the following simple text? How do I remove the Hours text from the results column, so that it only returns the numeric value without the text?   displayname=linkedname=directnamekey=actualworkrequiredquerysort=actualWorktextmode=truevaluefield=actualWorkRequir...

Thank you Doug...that worked.   I tried applying the same logic to the following string,  so that it would have the double digit after the decimal (10.00), but it didn't seem to work, and when I try replacing valueformat=compound with valueformat=doubleAsDouble, it defaults back to compound. I'm jus...

Hello, I was able to remove the word Hours from my numeric results, but does anyone know how I can modify the text below so that my results include a decimal point and a zero (.0), when the result is a whole number? For example, instead of 7, I would prefer the result display as 7.0, without affecti...