Help with formula

2.97K viewsFormulas and Functions

I need some help finding one or more Quantrix formulas to help me do something in Quantrix that was previously doing in Excel with VBA. I am trying to test a mapping scheme that I want to use aginst a GL extract. On the attached file on the “SP Ledger” matrix I want the “HFM Account” column to pull in the correct account based on rules in the “Account Mappping” matrix. I am at a loss for where to start here. Any help would be greatly appreciated. Thanks in advance.


Hi Scott,
I enclose a modified version of your model doing the lookup on the mapping table by means of last(selectlessthan()). It’s not immediately intuitive, but should work. The mapping table should contain a list of account number ranges correctly sorted and without gaps.
Hope this helps

You are viewing 1 out of 1 answers, click here to view all answers.