General discussion

Hello,
I have a problem is to calculate the interests of a term certificate of deposit, in relation to rate changes, where I have a previous rate and the current rate. To make the calculation with the current rate I have no problem, but I do have a problem in taking the remaining days from the date of change backwards. In other words, the client came and canceled on the 17th of May 5, 2022, he had a rate of (previous rate 4.00) and they changed it for 7.50 (Current Rate).

This is not the easiest thing to do in the equation editor as you are working with numbers, characters and dates. If you have the latest version of IDEA you can download the Custom Functions package from the IDEA lab.
hello, how do I display the IDEA functions that I import, because if I'm in the equation editor and press # it doesn't throw me the DateDifferenceforMonths.ideafunc function, I only get the new functions that I import from IDEA lab, the CWI, why won't you introduce them to me?

Hello, I was clearing space from my hard drive and realized i Have around 40 gb of temprary files and almost all of them .tvm files created from bases from my IDEA projects. When do this temporary files get created? what do they do? can I delete them?

how do i convert a pdf to idea any ideas

I have 90 Columns and I want the average of each column, but the only condition is to take the average of those whose values are more than 0. Like we do in Excel by using AverageIF(). How can this be done on IDEA?

hello, how to validate if an .IMD file is found in the working project directory to send a message to the user who must first verify that this file exists and then proceed with the execution of the tests.

hello, recently I downloaded the "APP UTILITIES" through the passport option, it happens that I downloaded a file with a .DPACK extension, when I double-click it is imported, but I don't know where to look for it or where to put it, could someone tell me where to put it? or the steps to run it and see the scripts

Hello, I have to get a list of the documents to expire, where I have today's date (@date), it happens that for future expirations I have to add a year to this date, I have tried with @year(@ date() +1 but it only gives me 2023 and I want the entire date, that is, if today we are at 2022/09/23, the new date must be 2023/09/23
How would I achieve this?

What is the ideascript for deleting a folder and all the imd files within the folder?

Hello, I am creating a pivot table in idea, and the script runs fine. The question is, how do I send this table to Excel through other scripts, since IDEA does not save it. any idea how to do it?, I want to automate all the tasks, but this is a small problem.