How to change the UI variable to Script variable?

[#1]

Hi Folks,

I have variable called vCrAmt, it is declared in UI side i.e., Settings>Variable Overview.

Now i am trying to call the same variable from Edit Script.

SET vCrAmt=SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt);

Can anyone help me to put the same in Edit Script....

I tried like this...

SET vCrAmt='SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt)';

getting no value..

Thanks in advance...

[sushil353]

Try this:

SET vCrAmt= '=SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt)';

[#3]

i will try and let u know

Thanks for the reply Sushil Kumar

[#4]

Hi Sushil,

I am trying like this, its not working..

SET vCrAmt='=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])';

[sushil353]

this must work..

how are you using this variable in your expression..? have u checked the same expression in text box?

[#6]

Yes Sushil,

Its showing this

'=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])' --> Text Object Expr