Differentiate negative from positive numbers

andre vieira shared this question ago

Answered

Hey, I'm trying to make a calculated field with the following logic

CASE WHEN (Param1 - Param2) >= '0' THEN 'POSITIVE' ELSE NEGATIVE

But he classifies all results as positve!

Param1 and Param2 are metrics

Replies (1)

Nathan Schroeder ●

Hi Andre,

Do you have a few minutes to screen-share so that I can see this first-hand? If so please let me know what time works best for you.

Regards,

Nathan

Reply URL

andre vieira ●

Hello Nathan. I can tomorrow, email me at andre.vieira@b3.com.br

URL

Nathan Schroeder ●

Hi Andre,

I have sent you an invitation for 11am MST, 9am EST, does this work for you?

URL