Questions on Custom Functions
.NOT. @isini for multiple strings
Hi... new here and to IDEA, I finally found this equation to exclude any Description that contains the word "lease": .NOT. @isini("lease", DESCRIPTION )
- Read more about .NOT. @isini for multiple strings
- 2 comments
- Log in or register to post comments
Usage of Custom Functions
Hello Brian/all,
I have a custom function that I want to share with my team. The challenge however is that unlike ordinary functions that are accessible to all projects, the custom function is accessible only from the project it was created on. Any idea on how I can make a custom function accessible from any project without having to copy it across?
- Read more about Usage of Custom Functions
- 1 comment
- Log in or register to post comments
Using Client Object in Custom Function
Is there any way to use the Client Object of Idea in a custom Function?
I want to use Client.RunIDEAScriptRV within my Custom Function.
- Read more about Using Client Object in Custom Function
- 1 comment
- Log in or register to post comments
Version 11.1 and scheduling
I have a script I need to run automatically on a certain date so I upgraded to version 11.1 in order to use the schedule function...well I currently cannot get Admin rights so the function will not work. I've got it set up in Windows Task Scheduler but it did not run this morning as set up. Is there a work around in version 11.1 that will allow me to use the scheduler without admin rights? Currently working from home so I'm connecting through VPN which may or may not be the reason the Task Scheduler didn't run but that certainly is stopping any progress towards admin right
- Read more about Version 11.1 and scheduling
- 6 comments
- Log in or register to post comments
Using a Variable in Equation Editor
Hi there,
I am trying to call the value of a variable created with this code:
Dim Materiality As Long
Dim PerfMateriality As Long
Dim SamplingThreshold As Long
Materiality = InputBox("Type in the Materiality for this client (to the nearest €).")
PerfMateriality=Materiality*0.5
SamplingThreshold=PerfMateriality*0.01
Now I am tryinh to append a field on the spreadsheet that would give me a yes or not as to the transaction is above or below the materiality or the sampling threshold.
- Read more about Using a Variable in Equation Editor
- 3 comments
- Log in or register to post comments
IF function with multiple criteria
Good afternoon,
I am trying to append a new field that return a value for each of the transaction recorded based on specific dates it is performed.
I am pretty new with the IDEA Script and the logic behind it. I come up with the following code;
- Read more about IF function with multiple criteria
- 4 comments
- Log in or register to post comments
Converting blank dates
Hi,
I have an employee masterfile where the Termination Date is in character. I created a new field with @ctod on the date but it gave me an error on blank dates, ie non-terminated employees.
As a resolution, I used @if to specify if the termination date field .NOT. isblank, then convert to date. However, I am not able to specify a blank date at the end of the @if function. What should I type to indicate as NULL date?
Thanks.
- Read more about Converting blank dates
- 4 comments
- Log in or register to post comments
Sorting letters within a string alphabetically
Hey everybody,
I hope that someone can help me with my problem:
I'm trying to built a function that can sort the letters within a string alphabetically.
I figured out how to do it in Excel, but I don't know how to get it done in IDEA Basic.
Journal Testing and related Functions
Dear Sirs,
i have to do a test for a bank journal entries , does anyone have a list of Test related to JE and how to do it , and if u can provide me with a list of all custom functions
that can be used in IDEA software,
finally , i'm trying to test if some entries have been done on holidays , can someone help me on how to do it using IDEA.
thank you in advance.
- Read more about Journal Testing and related Functions
- 2 comments
- Log in or register to post comments
comparing multiple character fields
Hi,
i would like to compare multiple character fields in IDEA to check if atleast 2 fields are the same. How do i do this through IDEA script?
Eg:-
Col 1
Col 2
Col 3
Col 4
Col 5
Exception
A
A
B
C
D
Yes
A
B
A
C
D
Yes
A
B
C
D
E
No
- Read more about comparing multiple character fields
- 5 comments
- Log in or register to post comments