Expression question

[msawyercke]

I’m creating a new table and need some basic assistance with a particular formula.

I have a file that I load that contains all our locations (identified our unique "PS #") and their associated trailing 13 period sales.  In a table, I’m trying to display the count of restaurants that are under $800,000, between $800,001 and $1,100,000 and above $1,100,001.

I tried using this formula for the 'Under $800k' category, but there is an error and it won’t calculate:

Count(DISTINCT {< ([Trailing 13]< 800000) >} [PS #])

Can someone advise a better formula to use in the table?  What would be the other two formulas?

Thanks to anyone who can help!  

[Ivan_Bozov · Accepted solution]

Try this:

COUNT({<[Trailing 13]={"<800000"}>}DISTINCT [PS #])

[msawyercke]

Thanks, Ivan!

What would be the expression for 'between 800000 and 1100000'?

[Ivan_Bozov]

This should work: COUNT({<[Trailing 13]={">=800000<1100000"}>}DISTINCT [PS #])

[msawyercke]

Outstanding and terrific - thanks very much!  Have a great day!

[Ivan_Bozov]

No worries. Same to you!