Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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
Thank you for your helpful information.
Can you please explain me how can i write new expression using replace function here.
Regards,