PI_Science

Discussions

Beast Mode Numbers Sorting Improperly
Hi all - I create the folling simple beastmode to find the number of days between two dates: DATEDIFF(`Date1`, `Date2`) The formula validated and the output reflected the correct number of days between the two dates - great! The problem is that the card that the beastmode is in does not seem to recognize the value of the…
CASE WHEN... AND in SQL ERROR
I'm working in MYSQL and trying to write a CASE WHEN Statement with multiple AND X<Y conditions. When it is finished, the statement below will be much longer with 15 more AND conditions, but right now this shorter version won't verify. The purpose of this statement is simply to find the lowest value across 15 columns for…

Beast Mode Numbers Sorting Improperly
Hi all - I create the folling simple beastmode to find the number of days between two dates: DATEDIFF(`Date1`, `Date2`) The formula validated and the output reflected the correct number of days between the two dates - great! The problem is that the card that the beastmode is in does not seem to recognize the value of the…
CASE WHEN... AND in SQL ERROR
I'm working in MYSQL and trying to write a CASE WHEN Statement with multiple AND X<Y conditions. When it is finished, the statement below will be much longer with 15 more AND conditions, but right now this shorter version won't verify. The purpose of this statement is simply to find the lowest value across 15 columns for…