Questions on Custom Functions

Hi... new here and to IDEA, I finally found this equation to exclude any Description that contains the word "lease": .NOT. @isini("lease",  DESCRIPTION )   

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?

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.

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

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.

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;

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.

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.

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.

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