Skip to Content
0
Former Member
Mar 05, 2009 at 10:30 AM

Edit the bar chart series value

22 Views

Hi experts,

Can I edit a bar chart series value or apply a string value to the series?

Example:

There are three values - startValue, newValue and newValuePercentage which needs to be summarized based on time scale.

The first two values are obtained from the database and the third value has the formula,

newValuePercentage = startValue/newValue * 100

startValue is applied the NthSmallest(1, someField) based on some time field.

newValue is applied the Sum(someOtherField)

If for a time span, the startValue is zero, i need to show the value of newValuePercentage as "N/A".

For this, i have created a formula to be given to the chart.

However, this formula is not getting displayed in the data tab that gets added to the chart.

As in crosstab, where i can edit the display string of any field, can i do it in the chart?

Thanks,

Roshan