insert 2 or 4 blank rows after specific row

Question

Hello,

How can i insert 2 or 4 blank rows after specific line(Total)

Output

Title$$A B C TOTAL D

Expected Output

Title$$A B C TOTAL NULL NULL D

Yoshiro_Fujimori · Answer

Hi @kauser ,

In the same way as [Title] column, you can nullify [$$] column in Formula tool.

Title = IF [RowCount] != 1 THEN Null() ELSE [Title] ENDIF

$$ = IF [RowCount] != 1 THEN Null() ELSE [$$] ENDIF          // Added

Input

Title$$A1B2C3TOTAL6D4

Output

Title$$A1B2C3TOTAL6    D4

1256353.yxmd

flying008 · Answer

Hi, @kauser

IIF([RowCount] != 1,IIF(ToString([_CurrentField_]) = 'Total', 'NULL', Null()), [_CurrentField_])

Input  Output Title$$ Title$$A1 A1B2 B2C3 C3TOTAL6 TOTAL6D4 NULL    NULL    D4

kauser · Answer

it doesn't solve the issue please try with input

Output

Title$$A1B2C3TOTAL6D4

Expected Output

Title$$A1B2C3TOTAL6NULL NULL D4