|
 hide "0" values in tooltips |
| Posted by Michael Opitz on Feb-08-2012 18:03 |
|
Hi Peter,
is it possible to hide "0" values that results from an image map calculation?
I need to show a time span in a gantt (box-whisker) formatted as d hh:nn:ss. I use the formula {=(({top}-{bottom})-({top}-{bottom})%86400)/86400|0} to calculate the days, but the days should not show if they are "0".
Example:
0 12:33:44 should display as "12:33:44"
3 08:15:23 should display as "3 08:15:23".
Is this possible without using external calculation and extra fields?
Regards,
Michael |
| Re: hide "0" values in tooltips |
| Posted by Peter Kwan on Feb-09-2012 01:29 |
|
Hi Michael,
Unluckily, there is no formatting string that can hide the zero value. The easiest method I can think of is to use extra fields. The alternative methods I can think of are all more complicated to me than the extra fields method.
For example, one alternative method I can think of is to insert a special marker in the image map, like:
3dsufg93w 08:15:23
Then after the image map is generated, you may use regular expression to remove "0dsufg93w " and also remove "dsufg93w" from the image map text string. This leaves the tooltip as what you want.
Regards
Peter Kwan |
|
Forum Home
Search
Message List
Post Message