Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

how can i do it

1 reply [Last post]
Tue, 2007-05-15 17:43
Ahmed Ewis
User offline. Last seen 8 years 51 weeks ago. Offline
Joined: 29 Jan 2007
Posts: 28
Groups: None
how can i show on Gantt chart on the task bar on the right side the % work done and on the left side the % of remaining work but to be percent not hours or days
Top

Replies

Tue, 2007-05-15 23:02
#1
Trevor Rabey
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Easy.
First, it is better to create a new VIEW for this, rather than changing one of the built-in VIEWs.

% Work Remaining = 100 - % Work Complete

Use a spare Number field/column, such as Number1, to do the calculation (Tools, Customise, Fields).

Number1 = 100-[% Work Complete]

Then use a formula in a spare Text field/column (Text1, Text2) to include the "%" sign and some title text for the display:

Text1 = [% Work Complete] & " % WORK COMPLETE"
Text2 = [Number1] & " % WORK REMAINING"

For convenience, rename Text1 and Text2

Text1: PERCENT WORK COMPLETE
Text2: PERCENT WORK REMAINING

Then use Format, Bar Styles, Text (tab) to show Text1 and Text2 on the ends of the bars.
Top