Using Varriables in Charts

[alec1982]

Hi Guys,

I have a column in one of my tables has the values as follow:

ID               MM

1                463+($(VV)/4)

2                463+($(VV)/4) +($(VV)/4)

3                463+($(VV)/4) +($(VV)/4) +($(VV)/4)

Where VV is a variable of Input Box.

I am trying to use MM in a chart as Sum($(=MM)) but it is not working..

Any idea on how can we do that..

Thxs,

Alec

[#2 · Accepted solution]

Hi,

    I think no need to use expression in load script according to my calculation your expression for Field 'MM' like this:

                  463+ ($(VV)/4) * ID

If this is correct then you can write this in chart expression also....please check my attach file and let me know.

Regards,

Ashutosh