Hi:

I´m creating a saved search to show how many items are at some locations. We have location A, B, C, D.

The field we would like to display {binnumber.location}

With only the info for each location.

The idea is to get a list of items:

Item           At location A       At Location B     At location D
RX 2                 34                       12                    1
MD 2                  4                         2                  34
PL 2                   3                         9                    0
WY 2              100                         8                    8

This is the formula
Type: Formula (Tex)

CASE WHEN {binnumber.location} EQUAL AFOSA CENTRAL THEN {binnumber.location} END

This is what i get a result:

ERROR: Invalid Expression


Can anyone help?

Thanks¡