Sigma Community

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

system automatically bumped May 21, 2021, 2:04am #12

system automatically bumped June 12, 2021, 12:55pm #13

system automatically bumped July 5, 2021, 9:15am #14

system automatically bumped July 28, 2021, 2:09am #15

system automatically bumped August 19, 2021, 10:32pm #16

system automatically bumped September 12, 2021, 10:33am #17

system automatically bumped October 6, 2021, 1:53am #18

system automatically bumped October 30, 2021, 4:28am #19

system automatically bumped November 23, 2021, 7:43am #20