rlopez | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Answers
Questions
Answer was selected as best
January 11, 201910
Received an upvote
Copy Data from Datalink to New Matrices

Vishnu, 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....

January 11, 201910
Received an upvote
October 29, 201810
Answer was selected as best
Multiple Selection of Categories

ShriShank, 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)...

October 29, 201810
Answer was selected as best
DataLink and other Scripts

tawanda, This is how you would delete the blank rows assuming that Category A of Matrix2 is in the Row position. //DeleteNonBlankRecordInCategory //By rlopez 10/15/2014 //Begin the For Each Loop |Matrix2::A|.items.each...

June 12, 201810
Answer was selected as best
IRR function

vishnuyarlagadda, I think I figured it out using sublist(), first(), last(). See the attached model and the Answer Item formula. It solved for Cash1. Let me know if this is what you were looking for....

June 12, 201810
Answer was selected as best
Filters

Vishnuyarlagada, I think this question can be answered by this post "Copy Data from Datalink to New Matrices" viewtopic.php?f=19&t=1034&p=3333#p3333"

June 12, 201810
Answer was selected as best
USING AS or Select

vishnuyarlagadda, Attached is a model with three different solutions. Monthly Consumption Select Monthly Consumption Using As Monthly Consumption Datalink As far as best practices, there are multiple...

June 12, 201810
Answer was selected as best
Sum across all subsequent items in a Year:Month Timeline

Jlin, 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...

June 12, 201810
Answer was selected as best
Recursion [PREV]

the answer is [PREV-n] n being the number of years minus 1 you want to go back. if the year is 2015 and I want to go back 2 years to 2013 it would be [prev-1].

June 12, 201810
Answer was selected as best
Using titles in presentation canvases

Here is the attachment. Rich Lopez

June 12, 201810
Answer was selected as best
Soft Recurrence as an arguments of the Min()

SAU, 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...

June 12, 201810
Received an upvote
Need a Script to add rows by clicking on Button

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...

June 5, 201810
Received an upvote
Loop Through and Delete Items

In scripting, I need to know the syntax to delete items where a cell value is not equal to a specified value. For example: [attachment=1:217udo9n]delteitems.JPG[/attachment:217udo9n] In the screen shot...

June 5, 201810
Received an upvote
June 5, 201810
Answer was selected as best
Loop Through and Delete Items

|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...

March 26, 201810
Posted an answer
August 16, 20175
Registered
July 27, 201710
Posted an answer
July 23, 20175
Posted an answer
May 30, 20175
Load More