General discussion
Trend Analysis
Forums
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
- Read more about Trend Analysis
- Log in or register to post comments
Python Function Error
Forums
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,
- Read more about Python Function Error
- 2 comments
- Log in or register to post comments
Using = as operator instead of @isini in a filter criteria
Forums
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).
Dato de fecha Juliano JDE a Gregoriano
Forums
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.
- Read more about Dato de fecha Juliano JDE a Gregoriano
- 8 comments
- Log in or register to post comments
PERCENTAGE
Forums
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
- Read more about PERCENTAGE
- 3 comments
- Log in or register to post comments
Highlighting Cells or Records
Forums
Can we highlight a cell or record in IDEA and export it to excel?
- Read more about Highlighting Cells or Records
- 2 comments
- Log in or register to post comments
rate change
Forums
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).
- Read more about rate change
- 7 comments
- Log in or register to post comments
does not introduce me DateDifferenceforMonths.ideafunc
Forums
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?
IDEA temporary files (.tvm) can I delete them? what do they do?
Forums
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?
convert a pdf to idea
Forums
how do i convert a pdf to idea any ideas
- Read more about convert a pdf to idea
- 1 comment
- Log in or register to post comments