Conditional Expression based on List Boxes

[#1]

I need some advice, I have a list box that has three values from an inline table:

100   Other

200   Purchase

300   Rental

I sum a monetary field and create a total for each of these values, so the table looks like this

Purchase      Rentals   Other     Total

###$            ###$      ###$      ###$

If the user selects Other I only want the Other and Total columns to show, If a user selects Purchase and Rentals I want only Purchase, rental and Total columns to show but NOT other.

What happens is if the user select one of the list choices only that field shows, I can also get all of them to show when nothing is selected by using getselectedcount = 0.  What I can't get is two of the fields to show.  So if a user selects BOTH purchase and rentals nothing shows. Is there a way to get this to work ?

[Carlos_Reyes · Accepted solution]

You can use SubstringCount. For instance, the conditional for the Purchase expresion would be the next:

SubstringCount( Concat ( Field, ' | '), 'Purchase')

If you want to make sure that Purchase is selected then you only have to add the GetSelectedCount function

SubstringCount( Concat ( Field, ' | '), 'Purchase')   AND GetSelectedCount( Field ) >=1

[#3]

Thank you Carlos, it worked like a charm !