[adallaway]

Hi,

Is it possible to do a comparison between a summed value and a non-summed value in the criteria summary fields?

For example:

Search Type: item

Search Summary Criteria: SUM({binonhand.quantityonhand}) > {somecustomitemfield}

Search Results: Name (Group)

It seems like to be able to do this you would need to be able to input {somecustomitemfield} into the “VALUE” field of the summary criteria. Unfortunately, it only allows for numeric input.

Thanks!
This is a cached copy. Click here to see the original post.

[errol]

Try:

SUM({binonhand.quantityonhand}) > MAX({somecustomitemfield})

[adallaway]

Thanks for the reply!

I discovered that same thing literally 30 seconds before your reply lol.

Thanks!

[Author]

Posts