rlopez | Reputations

Received an upvote	June 6, 2021	10
Answer was selected as best	January 11, 2019	10
Received an upvote	January 11, 2019	10
Received an upvote	October 29, 2018	10
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, 2018	10
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, 2018	10
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, 2018	10
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, 2018	10
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, 2018	10
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, 2018	10
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, 2018	10
Answer was selected as best Using titles in presentation canvases Here is the attachment. Rich Lopez	June 12, 2018	10
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, 2018	10
Received an upvote	June 5, 2018	10
Received an upvote	June 5, 2018	10
Received an upvote	June 5, 2018	10
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, 2018	10
Posted an answer	August 16, 2017	5
Registered	July 27, 2017	10
Posted an answer	July 23, 2017	5