replace any functions within the expressions with variables?

[manozpph]

Hi Guys,

Here in the Straight Table I have 3 expressions: 1.LineSalesAmount for (3 years)  2.Total Sales    3.Product Sales.

In Straight table,I need to  replace any functions within the above 3 expressions with variables to

improve user understanding.

Can Somebody help me how i can replace functions.......?

Thanks in Advance

[JonnyPoole]

Not sure exactly what you are asking but a couple of pointers:

If you expression is sum(Sales)  , then when you create a variable to replace the expression , give it a definition of:  sum(Sales)   . Do not include a preceding = sign . :This will ensure your expression is evaluated within the context of the chart and not outside the chart. Let say you created the following variable:

variable name:   vSales

variable definition:   sum(Sales)

Back in the expression definition in the chart your new expression will be:

$(vSales)

Thats all..

[danieloberbilli]

Go in Settings > Expression Overview (or press Ctrl+Alt+E) and use Find/Replace.

But be careful with this and use a test copy - you might replace expressions you would like to keep.

edited: sorry - didnt see that you were asking for variables...

Kind Regards

Daniel

[manozpph]

Thank you for your helpful information.

Can you please explain me how can i write new expression using replace function here.

Regards,