Rule Functions

TM1 Function for Rules – DELET

Available In

Rules and TurboIntegrator

Definition

​DELET function deletes a specified number of characters from a specified position within a string.  

Syntax

DELET (string, start, number)

String = A text string. 

Start = Position from where to begin deletion.

Number = The number of characters to delete. 

Video Demo

Use DELET function to remove characters from the string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.