Differentiate negative from positive numbers

andre vieira shared this question 3 years 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

Comments (1)

photo
1

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

photo
1

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

photo
1

Hi Andre,


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

photo