This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a doubt about the multirow formula tool. Regarding this image..
I am trying to create a formula that validates if the array contains the same number, three times in a row. If the array contains only one or two rows, then it needs to report which banking account has issues.
I already was able to determine a few parameters for the creation of this array, but I have no clue on how to create this next step.
Lets talk about transactions. All transactions that enter in the system (Example: Book transfer) after being received, it MUST be blocked (represented by "BALANCE BLOCKED") and afterwards it needs to be unblocked (represented by "BALANCE UNBLOCKED").
What I did was to create an array with those three steps Book transfer receivable -> Blocking -> Unblocking.
However, there are a few drawbacks in the system and sometimes a transaction is not blocked therefore, not unblocked. So what I need is a workflow that detects this lack of "blocking and unblocking" and reports in a browse tool for example which transactions did not get blocked/unblocked.
For this reason that I created this extra column called "Novo Campo" with the arrays