Problem with Above and line chart

[davoud-jelodar]

I have a problem with above function.

There is a table with Symbol,PersianDateHour and Price.

I use Dim="(PersianHour, Symbol" and Exp="(Price-above(Price))/above(Price)" as changerate.

For this in "Stright Table chart" everything is Ok. but when I change it to "Line chart" there is wrong.

I do not know why and how can I fix it. You can see sample file.

[davoud-jelodar]

value of "(Price-above(Price))/above(Price)" grater than -1 and less than 1 but in line chart there is biger than.

[sunny_talwar · Accepted solution]

Try this

Aggr((Price-above(Price))/above(Price), Symbol, PersianDateHour)

or this if you have QV 12 or above

Aggr((Price-above(Price))/above(Price), Symbol, (PersianDateHour, (NUMERIC)))

[davoud-jelodar]

Thank you.