insert 2 or 4 blank rows after specific row

[kauser]

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]

Hi @kauser ,

There might be better ways, but here is one way.

You can change the number of rows by changing the number '2' in Formula tool below.

IF [Title] = "TOTAL" THEN 1 + 2
ELSE 1
ENDIF

Workflow

[kauser]

Thanks for your suggestion but there are some problem. if you add value on $$ column suck if you have balance from Total row is 6 then this 6 amount will repeact with null rows. then how can i remove balances from null rows  

[flying008]

Hi, @kauser 

FYI.

[kauser]

it doesn't solve the issue please try with input 

Output

Title	$$
A	1
B	2
C	3
TOTAL	6
D	4

Expected Output 

Title	$$
A	1
B	2
C	3
TOTAL	6
NULL
NULL
D	4

[flying008]

Hi, @kauser 

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

Input			Output
Title	$$		Title	$$
A	1		A	1
B	2		B	2
C	3		C	3
TOTAL	6		TOTAL	6
D	4		NULL
			NULL
			D	4

[Yoshiro_Fujimori]

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	$$
A	1
B	2
C	3
TOTAL	6
D	4

Output

Title	$$
A	1
B	2
C	3
TOTAL	6
D	4