how can i do it
Forum Sponsor
Top Posters
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts
Peter Holroyd
51 posts
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.