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.