Error in Let statement

[Anonymous]

What is error in following statement?

let VMaxTrxnDate=max(TRXDATE);

[Anonymous]

if you find another way, it will be great

if not, you need to eat a sour apple (you may drop the resident table), the result is more important if it's the

only way to achieve what you want

[jagan]

Hi Balraj,

You cannot directly use Aggregare functions in LET statement instead you can try like below

MaxTRXDATE:

Load

      Max(TRXDATE) AS MaxDate

RESIDENT Invoice;

let VMaxTrxnDate=Peek('MaxDate');

DROP TABLE MaxTRXDATE;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

I want to use at backend only.

But no problem as shared by other, will do.