quantrix qa | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Received an upvote
Trouble opening file on new computer.

Sounds like an application version issue. Do you have the same version on your old and new computers? Help > About will give you the version numbers...

May 14, 202010
Received an upvote
@silent() function

Hello Luca - thank you for posting: I had to check with engineering on this one. 🙂 Its basically a way to return a single item multiple times along a different dimension... without the other dimensions...

January 23, 201910
Received an upvote
Month Ranges and YTD

Hi - Thanks for the post: There are 2 formulas you can write to calculate the YTD running total for all month and all items: 1. YTD Figures:Month[THIS] = YTD Figures:Month[PREV] + Monthly Figures:Month[THIS]...

November 6, 201810
Answer was selected as best
June 20, 201810
Received an upvote
Solved-Kinda

The RANK function has an optional third argument... either 0 or 1. If order is 0 or omitted, value_list is ranked in descending order (e.g. 34, 10, 6, 2, 1). Otherwise, value_list is ranked in ascending...

June 20, 201810
Received an upvote
June 20, 201810
Answer was selected as best
how to write science formulas in quantrix? like e=mc2?

Attached is a model file containing the formula and some values for T and V. Note that one formula is calculating all the results. The formula posted here seems to not be correct, so I did a bit of research...

June 20, 201810
Answer was selected as best
June 20, 201810
Received an upvote
Accumulated -- Revisited

Hello - thanks for your post: You can accomplish this by incoporating recurrence along both the MONTH and YEAR dimension. 2 formulas are needed. One for the first 12 months, and then one ongoing. Take...

June 20, 201810
Answer was selected as best
June 20, 201810
Received an upvote
Group Items

We have just released Quantrix Modeler 1.2 which includes the fix for this issue. Please see the Support page at Quantrix.com for update instructions. Regards, -Mike

June 20, 201810
Answer was selected as best
June 20, 201810
Received an upvote
Linking Across Models

We have just released Quantrix Modeler 1.2 that incoporates inter-model formulas used to link models. Please see the Support page at Quantrix.com for update instructions. Regards, -Mike

June 20, 201810
Answer was selected as best
June 20, 201810
Received an upvote
Copy Past Matrix

We have just released Quantrix Modeler 1.2 which includes pasting categories and matrices with linked categories. Please see the Support page at Quantrix.com for update instructions. Regards, -Mike

June 20, 201810
Answer was selected as best
February 27, 201810
Received an upvote
Use of [THIS] and [PREV]

Hello TPB – Thanks for posting your question. If I write it out your formula in words, it sounds like you are trying say that the PREVious months closing balance equals THIS months opening balance....

February 27, 201810
Registered
July 27, 201710
Posted an answer
July 26, 20125
Posted an answer
July 25, 20125
Load More