[nic kcd]

I have this as a results and works as intended. It is basically what tier a customer should be in.

HTML Code:
CASE WHEN SUM({amount}) > 50000 THEN ‘Platinum’
WHEN SUM({amount}) > 25000 THEN ‘Gold’
WHEN SUM({amount}) >= 12500 THEN ‘Silver’
WHEN SUM({amount}) 50000 THEN ‘Platinum’
WHEN SUM({amount}) > 25000 THEN ‘Gold’
WHEN SUM({amount}) >= 12500 THEN ‘Silver’
WHEN SUM({amount}) summary

summarize: maximum

formula(text): is false

Anyone have any suggestions? Thanks!
This is a cached copy. Click here to see the original post.

[erictgrubaugh]

You should be able to set up your Summary Criteria using Expressions and appropriate logical OR operators. I obviously don’t have the Customer Tier field, but setting up your Summary Criteria something like this should work:

You would of course replace my use of the Customer Status field with your Customer Tier field, and you would need to find the appropriate value for each Tier to place in the Description. Then use the Parens and OR operators to group the conditions appropriately.

If you set these up correctly, then any Customer showing up in your results should be in the incorrect Tier.

[nic kcd]

Ah I see what you did there, erictgrubaugh . That should work. Thank you much.

[Author]

Posts