topic Re: Reference Lines on line chart - changing the value display in App Development

Reference Lines on line chart - changing the value display

jerryr125 — Fri, 21 Jun 2019 11:14:29 GMT

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

Re: Reference Lines on line chart - changing the value display

sunny_talwar — Fri, 21 Jun 2019 12:36:53 GMT

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

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

Re: Reference Lines on line chart - changing the value display

jerryr125 — Sun, 23 Jun 2019 09:22:16 GMT

hi - thanks for the reply - appreciate it!

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

thoughts ? Jerry

Re: Reference Lines on line chart - changing the value display

LReeve — Mon, 24 Jun 2019 10:17:17 GMT

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.