What is the difference between using “=” before a variable and when it is not used?

[manozpph]

Hey Guys Can Some body Let me know the Answer for this Question.

What is the difference between using “=” before a variable and when it is not used?

Thanks In Advance!

[jagan · Accepted solution]

Hi,

Giving = in variable will evaluate the expression and stores the result in variable, if we do not give = then the expression is stored as string.

For example:

vSales : =Sum(Sales) - then Total sales is calculated (Assume total sales is 1 Million)

vSalesExpression : Sum(Sales) - this will store Sum(Sales) as string

Now in a chart if you have a dimension Customer and use the above expression

=$(vSales) - for all the customers you will the same sales amount 1 Million, since it is already evaluated.

=$(vSalesExpression ) - will calculate the sales for each customer, $(vSalesExpression ) will simply put Sum(Sales).

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

check this links, hope it helps you.

The Magic of Variables

http://www.naturalsynergies.com/q-tip-6-those-tricky-sign-expansions/

Regards,

Jagan.

[manozpph]

I have gotten the Answer.

Thank you so much for your help.