Format two Time fields within Percent Bar Chart

[gillonia]

CR 9, Oracle DB

I have two formulas which display two times which I'm trying to create a basic percent bar chart against. The first formula is the average time above SLA and the 2nd is the average time below SLA, e.g. 09:22:23 01:16:19.

This is so I can show each component's proportionate part of the total. I presume that we can do this with time fields as I have done this with percentages, ie 90% on one side and 10% on another.

However it's showing up in my chart as an equal split (ie half bar chart one colour and half another), I've tried formatting the chart under Chart Options -> General -> Numbers Tab then changing the category to time. I'm very confused so I'd be extremely grateful for any assistance.

Thnx for any advice.

 

[pgtek]

hi
check this

http://support.businessobjects.com/library/kbase/articles/c2000255.asp

cheers

pgtek

 

[gillonia]

Thanks for the reply pgtek, but this relates to V5 of Crystal reports. In V9 I don't have an option under the 'Type' tab for PGeditor. Any other suggestions? I've checked Crystals support site to no avail...