IDEAScript Questions

Hi all,
 
I was wondering if there's a function or script that's similar to the "Sumif" formula in Excel? I'm trying to eliminate expense reversals and in Excel, I use the following sumif formula to achieve this:
=IF(SUMIF($BA:$BA,$BA2,$AU:$AU)=0,"Yes","No")
Where column BA is the unique expense number (which can be the same if there's a reversal of expense) and column AU is the expense amount.

Hello, 
I have a macro that I use on a weekly basis. In the macro I have a spot for an input date for the weekly analytics. This input date is always the previous Monday date, for example next week when I run the macro the input date will be 03/07/2022. 
I also have an input date for analytics where I use five weeks of data. This input date is always the fifth Monday from the current Monday, for example next Monday the input date will be 02/07/2022. 

Hi Brian,
I hope you are doing great.
I have created a dialog box in a few days so I added a couple of keys and editbox in diffrenet places on my dialog box.
When we run the dialog to fill the blank boxes out, if we use tab key on the keyboard, the orders is based on the order we have created.
For instance, afterI filling out the project name, it goes to Help button, then it goes to Entity codes and so on. Is it possible to change the orders based on the order on my dialog box?
 
Thanks,
 

Hi everyone,
 
I hope you are doing great.
I have got some errors while I was updating some extraction with defined variables.
Below are some examples:
036 is character (because of leading zero)
"ENTITY" is a cloumn name (we did not define field names in the dialog box) but "sEntity" is defined for entity number.
How can I update "036" with "sEntity"?
-- task.AddExtraction dbName, "", "ENTITY == ""036"""
I tried below, for instance, but it did not work.

Greetings
I am processing 70 million records in iIDEA, the PC becomes very slow when trying to join the table that has 70 million records with the header table to get the accounting movements of a period, the question is, would I have to change the PC for one with higher processing power and more memory? Well, this union lasts approximately more than 8 hours, where I had to reset the PC and it does not make the union. The union is made between the transaction account and the header account.
what dou you recommend ?

Hello everyone,
do you have any scripts that convert vertical to horizontal data?

month and years elapsed between two dates?2021-10-20 - 2018-09-30 =? Years2021-10-20 - 2018-09-30 =? month

Hello everyone.
I have a date in IDEA format of the form YYYYMMDD, how do I remain one day from that date?
Example
20211210 and I get 20211209, and place the result of the other date in a field and then make a join  by dates
thanks for your help
 

Hi,
I need two variables that can be used in the two different functions within my macro, but instead of defining the variables within each function, I would like to define them at the begining and make them usable for all functions, but I cannot make it work. Somebody that has done this before? Thanks
 
Sub Main
'define variables  
Dim Qtr As String
Dim FY As String
Qtr = "Q4"
FY = "21"
 
Call TopNExtraction()'T&E Report - Q4 FY21.IMD
Call AppendField()'T&E Report List.IMD
End Sub

I have an oracle database, and I need to extract the records from a table with the built-in idea odbc. the question is how do I substitute those form dates in the odbc import
example
 
bName = "tca_xxxIMD"