Reference Lines on line chart - changing the value display

[jerryr125]

Hi - 

I have a line chart displaying a reference line using the following formula:

=Avg(aggr(sum(AMOUNT), [DATE]))

Question - when the value appears how do I remove the "( )" around the value ?

Example : the reference line is displaying "(10,000)" and I would like it to display "10,000"

thoughts ? Jerry

[sunny_talwar]

Is this because it is a negative number? May be you need fabs to make it positive

=fabs(Avg(aggr(sum(AMOUNT), [DATE])))

[jerryr125]

hi -  thanks for the reply - appreciate it!

The number is positive so it is displaying the ( ) for positive numbers.

thoughts ? Jerry

[LReeve]

Hi Jerry,

Unfortunately I think this is how the reference lines are displayed and have nothing to do with the value it self - As far as I know this cannot be changed using stock charts.