|
About the Formulas and Functions category
|
|
0
|
83
|
March 18, 2020
|
|
Converting Text to Date shows Null
|
|
23
|
169
|
December 7, 2021
|
|
Adding Leading Zeros
|
|
22
|
157
|
December 7, 2021
|
|
Finding Sum for Previous 7 Days not Including Today
|
|
21
|
173
|
December 7, 2021
|
|
Non-Alphabetical Custom Sorting
|
|
24
|
217
|
December 6, 2021
|
|
Naming Days of the Week
|
|
21
|
198
|
December 6, 2021
|
|
Changing Timezone of Data
|
|
21
|
164
|
December 6, 2021
|
|
Formatting Dates to be Similar
|
|
20
|
144
|
December 6, 2021
|
|
Adding Values Resulting in Nulls
|
|
22
|
178
|
December 6, 2021
|
|
Right Click Expand
|
|
20
|
123
|
December 5, 2021
|
|
Grouping by more than one dimension the same level
|
|
20
|
139
|
December 5, 2021
|
|
Converting Hstore to JSON
|
|
14
|
106
|
December 5, 2021
|
|
What are Pass Through functions?
|
|
15
|
168
|
December 5, 2021
|
|
H lookup within sigma?
|
|
20
|
169
|
December 4, 2021
|
|
Filling in a Column with Coalesce not Working
|
|
22
|
240
|
December 4, 2021
|
|
Changing Date into "YYYY-Q"
|
|
21
|
169
|
December 4, 2021
|
|
Do excel downloads include column formulas?
|
|
19
|
113
|
December 4, 2021
|
|
Multi-select Parameters in Workbooks (Calculated Fields)
|
|
3
|
177
|
December 4, 2021
|
|
Multi-select Parameters in Workbooks (hand-written SQL source)
|
|
3
|
153
|
December 3, 2021
|
|
Finding Customers First Purchase
|
|
21
|
133
|
December 3, 2021
|
|
IRR and NPV functions
|
|
21
|
211
|
December 3, 2021
|
|
Avg if, median if
|
|
21
|
198
|
December 3, 2021
|
|
Trend forecast formula/function
|
|
20
|
250
|
December 3, 2021
|
|
If contains, then xyz
|
|
21
|
236
|
December 2, 2021
|
|
Product Aggregation
|
|
20
|
128
|
December 2, 2021
|
|
I have a one- or two-digit number that I want to convert to text, retaining the leading zero
|
|
21
|
176
|
December 2, 2021
|
|
"OR" Condition on Filters
|
|
21
|
196
|
December 2, 2021
|
|
Why lead function does not work on my worksheet?
|
|
15
|
121
|
December 2, 2021
|
|
Parameter Date Truncation
|
|
21
|
185
|
December 1, 2021
|
|
How to build a hyperlink with a custom title
|
|
22
|
165
|
December 1, 2021
|
