How to use expressions in edit script?

[udaya_kumar]

Hi,

I have huge expression to be calculated in the chart.

So everytime the object is active, it is calculating and it is giving performance issue.

So how can i use these expressions in edit script and then use simple expression in expression field in chart?

Can someone help me?

[er_mohit]

i didnt get u. what u exactly want .. so plz explain it briefly

[#3]

plz explain it briefly

[Peter_Cammaert]

A quick reply before we get more details:

Precalculate what you can in Load script. Use aggregation tables where needed. Memory is cheaper than user patience.

Peter

[udaya_kumar]

I have very big expression in chart,

now for ex,

vSales = sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} LineSalesAmount)

Consider this example,

here i want to use this expression in edit script instead of chart.

In chart, i need to make it very simple like

=vSales

in expression in the chart.

so that the calculations will be done in the edit script itself

[udaya_kumar]

Hi pcammaert,

Can you give me an example?

so that i can check it and try it.

[Peter_Cammaert]

What do you mean by "edit script"?

[udaya_kumar]

hi,

Edit script means, where we write load script or SQL select script.

the edit script window (Ctrl + E)