Formulas and Functions

Generic selectors

Exact matches only

Exact matches only

Search title only

Search title only

Search in content

Search in content

Search in excerpt

Search in all posts

Search in all posts

Search in pages

Search in pages

Answers

Answers

Questions

Questions

Formulas and Functions 237 Questions

Ask question

Search

Order By: New

Tag

Clear Filter

0 Votes 5 Ans

Reference Formula

532 viewsS A U Answered question May 3, 2019Formulas and Functionsformula

0 Votes 3 Ans

Countif – Nested conditions

616 viewsS A U Answered question March 7, 2019Formulas and Functions

0 Votes 2 Ans

How to adjust the value based on Flag

552 viewsS A U Edited answer February 22, 2019Formulas and Functionsformula

0 Votes 3 Ans

How to delete a row in 2 dimensional Matrix

Solved634 viewsJames Kipling Selected answer as best February 13, 2019Formulas and Functions2D matrix formula modeler

0 Votes 2 Ans

Any way to automatically update Item Names based on criteria?

686 viewsjlin Answered question November 27, 2018Formulas and FunctionsCategories scripting

0 Votes 4 Ans

Pareto – 80/20 Rule

1.04K viewsdenis.piquerez@gfimetrics.ch Answered question November 18, 2018Formulas and Functions

0 Votes 2 Ans

Sum formula facing SIZE issue

Solved681 viewsvpluchet Answered question November 14, 2018Formulas and FunctionsSIZE Sum

0 Votes 3 Ans

Model becomes slow

770 viewsvpluchet Edited answer November 13, 2018Formulas and Functionsfunction Slow USING AS

0 Votes 3 Ans

Timeline recursion does not skip summaries

728 viewsjlin Answered question November 27, 2018Formulas and FunctionsRecursion Timelines

0 Votes 2 Ans

Summarise data by a criteria which is in another matrix

Solved604 viewsvpluchet Answered question October 29, 2018Formulas and FunctionsAverage select Summary

0 Votes 2 Ans

How do I constrain output to be zero or positive numbers only?

Solved734 viewsJames Kipling Selected answer as best October 29, 2018Formulas and Functions

0 Votes 1 Ans

Category = sum of a group in another matrix

926 viewsQuantrixAuthority Answered question July 26, 2018Formulas and Functions

0 Votes 1 Ans

Quantrix Consulting Opportunity

1.88K viewsquantrix_essla Answered question June 14, 2018Formulas and Functions

0 Votes 6 Ans

Sage 50 link with Quantrix

2.21K viewsmarcodelgreco Answered question June 19, 2018Formulas and Functions

0 Votes 1 Ans

Suggested workflow for true ad-hoc Drill Down from DataNAV?

1.47K viewsbrian cabana Answered question June 18, 2018Formulas and Functions

0 Votes 4 Ans

Unable to extract data wrt Month from Two different Matrix

Solved1.67K viewsqdirector Selected answer as best June 12, 2018Formulas and Functions

0 Votes 2 Ans

If function does not extend across years

1.59K viewsQuantrix Administrator Edited question June 4, 2018Formulas and Functions

0 Votes 2 Ans

Invalid Error for Month

Solved1.86K viewsS A U Edited answer September 22, 2018Formulas and Functions

0 Votes 1 Ans

Select function error

Solved2.30K viewsqdirector Selected answer as best June 12, 2018Formulas and Functions

0 Votes 1 Ans

#Size Error while using Select Function

Solved2.48K viewsqdirector Selected answer as best June 6, 2018Formulas and Functions

1 2 3 … 11 12 Next »