max total date with where condition

[Uri]

Hi guys,

I want to create a variable which I will use further in NPrinting "Enable dynamic naming".

max(total date) where company_id = 'XXXXX' and where in myfield = 'XXXXX'.

Can someone help?

BR,

Artur

[GaryGiles]

Have you tried using set analysis?

max({$<company_id={'XXXXX'},myfield={'XXXXX'}>} total date)

[Uri]

Cool! It works.

Thanks!

How can I convert this to a variable?

[GaryGiles · Accepted solution]

Just paste the expression into the definition of the variable and then use the $-expansion

$(vVariable)

Assuming vVariable is the name of your variable.