Creating Variable

[#1]

Hiii To All,

I m creating one variable:

LET $LastPrice=Tax+[Unit Price];

M adding Tax and Unit Price but m getting string as it is in my straight table.its not evaluating the expression.

Thanx & Regards,

Qliker.

[MK_QSL]

Create Variable as below

eLastPrice=SUM(Tax)+SUM([Unit Price])

now use

=$(eLastPrice)

[#3]

I have tried like this bro but again m getting double value.

[Chanty4u]

hmmm

The Magic of Dollar Expansions

The Magic of Variables

[mangalsk]

Hello,

LOAD * Inline

[

Tax,Unit Price

100,200

];

LET $LastPrice='Tax+[Unit Price]'

This is example script and in chart just do

=$($LastPrice)

[Anil_Babu_Samineni]

Omno,

Without quotes how to use LET from scripting?

[Anil_Babu_Samineni · Accepted solution]

Abhishek,

Simple use your Dimension and create one variable like

LET Sample = 'Gross + Salary';

Then create chart with that dim and use this expression $(Sample)

-- Anil

[#8]

M using without quotes nd its working.

[Anil_Babu_Samineni]

Check your Variables (Ctrl + alt + v) then see, is that variable in created overthere. If yes, Cool ..