Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try this:
SET vCrAmt= '=SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt)';
i will try and let u know
Thanks for the reply Sushil Kumar
Hi Sushil,
I am trying like this, its not working..
SET vCrAmt='=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])';
this must work..
how are you using this variable in your expression..? have u checked the same expression in text box?
Yes Sushil,
Its showing this
'=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])' --> Text Object Expr