Showing Numbers That are Negative and Positive

Sigma Formulas and Functions

ztrean October 28, 2020, 10:23pm #1

Is there a easier way to show if a value is negative or positive than using the formula:

If([column] < 0,“negative”,“positive”)

Ryan October 28, 2020, 10:24pm #2

Hey Zachary!

You can use the “Sign()” function for this!

system automatically bumped November 14, 2020, 12:35pm #3

system automatically bumped December 4, 2020, 1:02am #4

system automatically bumped December 23, 2020, 1:16pm #5

system automatically bumped January 12, 2021, 5:08pm #6

system automatically bumped February 2, 2021, 1:16am #7

system automatically bumped February 23, 2021, 11:13am #8

system automatically bumped March 16, 2021, 9:14pm #9

system automatically bumped April 7, 2021, 11:07am #10

system automatically bumped April 29, 2021, 6:12am #11