nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to increment based on empty rows

LargeElk892

Hi,

I'd like to create a new column formula that increments (1, 2, 3....) only when empty rows are found (e.g. column 7 below).

Would you have a solution?

Thank you

Accepted answers

txnelson

Here is one way to handle your issue. Assuming that all of your columns are numeric, this will work

As Constant(
	count = 1;
	lagFlag = 0;
	dt = Current Data Table();
);
If( Is Missing( Sum( dt[Row(), 0] ) ) == 0,
	If( lagFlag == 1,
		count++;
		lagFlag = 0;
	)
,
	lagFlag = 1
);

If( lagFlag == 0, count );

All comments

jthi

Using formula with Lag() is most likely easiest option. Could you provide example with the result you want to have?

txnelson

Here is one way to handle your issue. Assuming that all of your columns are numeric, this will work

As Constant(
	count = 1;
	lagFlag = 0;
	dt = Current Data Table();
);
If( Is Missing( Sum( dt[Row(), 0] ) ) == 0,
	If( lagFlag == 1,
		count++;
		lagFlag = 0;
	)
,
	lagFlag = 1
);

If( lagFlag == 0, count );

LargeElk892

Thank you very much Jim! I took me quite some time to go through each block to understand the logic but I finally got it