General discussion

Hi Brian,
is there a limit how many cases a @compif function can handle or is there a a limit for the length of an equation?
Thanks in advance!

Hello everyone.
I recently placed a menu on the ribbon custormerize Ribbon that calls different macros, it happens that everything worked perfectly, but when I installed another laptop, it decides to go back again to recreate my menu, that is, install it again on the ribbon, but now every time I run a menu option, it throws an error: invalid macro name. When I go to the error line within the macro, this line is blank, and so for each menu option, always the same error.
That could be happening?

I test exceptions where i get results on a daily basis. These exceptions vary on various days. For example ivoices that were not taxed
I get these results in IDEA  daily. 
Monday i have a list of 9 invoices
Tuesday  15 invoices
wednesday 70 invoices
 
How would i go about showing this trend analysis based on daily results? Trend also can be based on monthly.

I test the use of cards and get the below results.
Monday

W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS

0
1051
47.41
9123.800
47.83
NO CARD USED

1
1166
52.59
9953.000
52.17
CARD USED

Tuesday

W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS

0
3000
30.00
302005.00
30.00
NO CARD USED

Hi Brian
Hope you are doing well
I got an error this morning with the same script that I have been running for a year. I never had this error before!
Would you please help me to solve it? I attached the error window and my python code.
 
Thanks,
 

Hi,
suppose I have an IDEA table where I have a string column. It contains strings and some of them start with a specific character pattern:
 
Column1
Thisisastringentry
anotherone
AB1Cstringcontainsapattern
doesnotcontain
AB1Cthisstringalsocontainspattern
AB1Cagain
 
 
Now I want to filter those entries that contain "AB1C". I would normally use @isini("AB1C",Column2).
 
 

Tengo una columna de que me traen fechas pero esta en formato Juliano JDE un ejemplo seria "118150" y eso significa "30/05/2018" para hacer esa conversión use la página de JDE edwards. Lo que quiero hacer es agregar un campo virtual y que me transforme esa fecha juliana y me de como resultado la fecha normal.

I am looking for a way to calculate percentages. See the sample data below. I have summarized clerks based on their transactions using criteria called the use of cards =denoted as 1 or no card used denoted as 0.  I need a way of giving percentages based on the clerk's total number of records. for example below Alice  (302/319)*100 Also how to do a total summary of cards used.

 
See the below the expected result as done manually in excel
 
 

Can we highlight a cell or record in IDEA and export it to excel?

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).