Filtering a variable

[#1]

Hi Guys,

Ok so basically what im trying to do is get the Maximum date of a specific field in a variable

Set LastUnconfirmedSaleDate= =max( { 1 <Product={'*'}> , <ref = {'U'}>} Dates);

it must be for all products and the ref must be for U can someone correct my syntax/Logic ?

Regards

Curt

[Anonymous · Accepted solution]

You don't need the middle angled brackets, so try:

Set LastUnconfirmedSaleDate= "=max( { 1 <Product={'*'},ref = {'U'}>} Dates)";

Jonathan

[jagan]

Hi,

Try this

LET LastUnconfirmedSaleDate= max( { 1 <Product={'*'} , <ref = {'U'}>} Dates);

Regards,

Jagan.

[#4]

Thanks that works , slightly off topic but is there a way to get the sum from only a single table

I.E. Set TotalAgents= =count({1} salesCode); I only want the count of salescode from oen table(agents) and not from the joining tables so i basically want to excludes sales codes from any other tables

[Anonymous]

When you load in your tables create a duplicate of the field you are interested in, on the table you're interested in, and count that instead.

Else you can create a field with a value of 1 and do a sum on that field. That would be more efficient.

Jonathan