Skip to main content

Powerful @Functions in IDEA for Fraud Analytics

Hi All,

The @Functions in IDEA are well distributed between Numeric, Character, Date and Time fields.

@Functions can be deployed through Field Manipulation for computations and / or through Extraction for condition based filters.

Listed below are a few @Functions which are most effective in Fraud Analytics.

@isini

Used to look for an occurrence of a word in a character field.

Example - @isini("gift", narration) will look for the word gift in a general ledger narration

@dow

Used to locate transactions on a weekend.

Example - @dow(RemittanceDate) = 1 will look for all loan remittances on Sunday

@strip

Used to eliminate special characters and spaces from any character field.

Example - @strip(Vendor Invoice Number) will remove special characters and spaces from a Vendor Invoice Number field reference and allow effective duplicate invoice identification

@isblank

Used to detect blank character fields.

Example - @isblank(Payee Name) will allow for detection of blank Payee Names in a Pay Ledger.

@betweentime

Used to detect specific time points between defined time ranges.

Example - .NOT. @betweentime(Approval Time, "09:30:00", "18:00:00") will detect approval time points outside working hours for the entity.

Electronic data may be deliberately recorded in a sub-optimal form to create loop-holes in the system or circumvent internal controls or create a sleight of hand modus to conceal frauds. IDEA's @Functions are best suited to detect such planned attempts to defraud an entity.

Kind Regards

Jairam