Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
i didnt get u. what u exactly want .. so plz explain it briefly
plz explain it briefly
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
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
Hi pcammaert,
Can you give me an example?
so that i can check it and try it.
What do you mean by "edit script"?
hi,
Edit script means, where we write load script or SQL select script.
the edit script window (Ctrl + E)