|Matrix1::B|.items.each { if (!|Matrix1|.getSelection(it, |Matrix1::Use|).value.equals(“YES”)) it.delete() } Thanks to the IDBS Support desk on this one. As a note the exclamation point “!” in...

View Question# rlopez | Answers

ShriShank, Say you have a Matrix Called Matrix1 with a category of "B" this is the syntax to use: |Matrix1::B|.children.create(1) If you want to add 1 item to the category B you would...

View QuestionShriShank, The filter capabilities that you describe don't quite work the same way in Quantrix as they do in Excel. Perhaps this video Episode 190 of the Quantrix Authority (https://www.youtube.com/watch?v=B6zxfvRgWSE)...

View QuestionJlin, In regards to your first question formula B5: I too have received a similar error when trying to do a running sum. Here is the explanation from Quantrix that I received on this question. [quote:ovcd8n2d]Quantrix's...

View QuestionVishnu, Per Mike's invitation "If anyone else has a different way to approach this question don't hesitate to post." I have the following. Solution: RichFilter Helper Example 1. Create a filters matrix....

View QuestionMarcodeigreco, Welcome to the world of Quantrix. Best business decision ever. I'm not familiar with Sage 50, but if you can export any of the data to csv then importing from csv into Quantrix is pretty...

View QuestionFor reference attached is the model with both examples provided by SteveB and SAU. Thanks again!

View QuestionSAU & SteveB Your answers are just what I needed. You are Quantrix Masters. THANK YOU!

View QuestionSteveB, Thanks for posting on how to use SelectList. It is indeed AWESOME. I can't seem to make it work with a nested list function in the third argument or lookup_value_list. In the attached model...

View QuestionSAU, I would say this is a bug. I've also tested this using the Max Function and the same results. I've tried multiplying by 1 the soft recursion (M1::B[~PREV]*1) no success. Even checking the help...

View Question