SET analysis expression into a Variable

[Uri]

Hi,

My idea is to create a variable that I will use in NPrinting after.

date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')

I tried this way but it didnt work.

LET vNPrinting =  '=date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')'

Can anyone help?

[Chanty4u]

is this working ?  without variable?

date(date#(max({<FIELD1={'XXXXXXXXXX'}, FIELD2={'xxxxxxxxxxx'}>}total FIELD3),'YYYY-MM-DD'),'YYYYMM')  

[Uri]

Hi @Chanty4u ,

Yes, it works if I apply this in my table.

BR,

Artur

[Uri]

Any ideas on this? 🙂