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