Need help creating a graphical report with tier ranges, please see formula below.
I need to create a graphical report that tells us how many customers fall into certain sales tiers based on their YTD Revenue. I was told I would need to use CAST and CASE for what I need to accomplish. I have written the following.
CAST(CASE WHEN "- YTD Revenue"."YTD Revenue" > 2000000.00 THEN '> $2 Million'
WHEN "- YTD Revenue"."YTD Revenue" >= 500000.00 THEN '$500K - $2 Million'
WHEN "- YTD Revenue"."YTD Revenue" >= 200000.00 THEN '$200K - $499K'
ELSE '< $200K'
END AS VARCHAR)
I am receiving the following error message when I try to save the above statement.
[nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <)>: Syntax error [nQSError: 26012] . (HY000)
0