Rule Functions

TM1 Function for Rules – DELET

Available In

Rules and TurboIntegrator


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


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.