|
About the Formulas and Functions category
|
|
0
|
20
|
March 18, 2020
|
|
Making a Column of Strings All Uppercase
|
|
7
|
22
|
February 25, 2021
|
|
Calculating number of weekdays from end of month
|
|
9
|
33
|
February 25, 2021
|
|
Turn Nulls into 0s
|
|
9
|
42
|
February 24, 2021
|
|
Sigma bitwise expressions
|
|
3
|
19
|
February 24, 2021
|
|
Formula for 3 business days from a given date
|
|
8
|
21
|
February 24, 2021
|
|
Excels VLookup Function
|
|
9
|
31
|
February 24, 2021
|
|
Setting Default Parameter Date to 'Yesterday'
|
|
9
|
26
|
February 24, 2021
|
|
Rate of Return on Investment Formula
|
|
7
|
18
|
February 23, 2021
|
|
Calculating Distance Between Two Locations
|
|
7
|
43
|
February 23, 2021
|
|
Showing Numbers That are Negative and Positive
|
|
7
|
25
|
February 23, 2021
|
|
Correlation Formula
|
|
7
|
22
|
February 23, 2021
|
|
Calculating Percentile Value of a Column
|
|
7
|
27
|
February 23, 2021
|
|
Converting Numerical Months Into Month Names
|
|
9
|
24
|
February 22, 2021
|
|
Truncating a Date After Already Being Truncated
|
|
9
|
24
|
February 22, 2021
|
|
Backup Join Keys
|
|
10
|
28
|
February 22, 2021
|
|
How can i return 'True' if it is found anywhere in my boolean column
|
|
9
|
26
|
February 22, 2021
|
|
NOT Operator Functionality
|
|
9
|
20
|
February 22, 2021
|
|
What is the best way to extract a Postgres hstore column in sigma?
|
|
7
|
23
|
February 21, 2021
|
|
Removing duplicate rows in a worksheet
|
|
7
|
35
|
February 21, 2021
|
|
Extracting Characters From a String
|
|
9
|
25
|
February 21, 2021
|
|
Show all rows when Data Source Parameter is empty
|
|
8
|
25
|
February 21, 2021
|
|
Joining multiple datasets so they add new rows instead of columns
|
|
12
|
62
|
February 20, 2021
|
|
Expected Date Format
|
|
8
|
19
|
February 20, 2021
|
|
Pacing Formula - Useful for tracking budgets and other monthly goals
|
|
9
|
34
|
February 20, 2021
|
|
Replacing Nulls With Zeros
|
|
9
|
31
|
February 20, 2021
|
|
Total Sum for Previous Three Months
|
|
7
|
23
|
February 20, 2021
|
|
Non-Alphabetical Custom Sorting
|
|
9
|
27
|
February 19, 2021
|
|
Removing Space on Column Values
|
|
9
|
25
|
February 19, 2021
|
|
Listing Values in a Group
|
|
9
|
28
|
February 19, 2021
|
