Welcome, Guest

CASE WHEN [variable] IS < 0 THEN 0 ELSE [variable
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: CASE WHEN [variable] IS < 0 THEN 0 ELSE [variable

CASE WHEN [variable] IS < 0 THEN 0 ELSE [variable 7 months, 3 weeks ago #1786

Hi Lenny,

I'd like to use the following expression as a part of an advanced custom variable:

CASE WHEN [variable] IS < 0 THEN 0 ELSE [variable] END

Where do I go wrong? How do I get it to work?

Thanks in advance
Wanja

Re: CASE WHEN [variable] IS < 0 THEN 0 ELSE [variable 7 months, 3 weeks ago #1787

  • admin
  • OFFLINE
  • Administrator
  • Posts: 156
  • Karma: 5
You should remove the "IS" from the expression.

CASE WHEN [variable] < 0 THEN 0 ELSE [variable] END

should work.
The following user(s) said Thank You: buffett1951
  • Page:
  • 1
Time to create page: 0.09 seconds