SQL CASE Statement

[wallacedavidl]

Hey, Team -

I'm not using SUM. Following is a sample custom statistic CASE statement converted from an IF statement:

CASE
WHEN (my_vpip > .00 AND my_vpip < .11)
AND
(my_pfr >= (my_vpip - my_pfr))
THEN format('NIT')
ELSE format('-')
END

In an IF statment construct, the format fuction works OK, but within a case statement an Error returns for an Invalid Value Statement.
Thanks,
David

[Flag_Hippo]

As far as I am aware you cannot use CASE directly in statistics like that so you will need to use an IF statement.

[wallacedavidl]

Ok, thanks. Happy holidays.