Formula tool

[akmuthu]

I get a 0 and -1 in a new column after performing a calculation in Formula tool. What does 0 and -1 represent? Please help. Thanks.

[ShankerV · Accepted solution]

Hi @akmuthu 

The 0 and -1 represents the Boolean value of True or False.

True - -1

False -0

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @akmuthu 

-1 means True and 0 means False. You can check this on the attached workflow, when the datatype of the Result column is changed to boolean, the label of the data will change to True/False.

[akmuthu]

Hi @Felipe_Ribeir0,

Your workflow clearly explains my doubt. Appreciate it!

[akmuthu]

Hi @ShankerV 

Thank you so much for your explanation. I get it now.