Cleaning script for formatting a table: to delete all calculations when N is lower than X
If you want to remove all calculations when the count cell is < X , then apply the following cleaning script In your tab settings:
In our example n=10 . . .
dim nIndexX=2'Start columnn index for count
dim nCals=3 'nb of calculations in row
dim nBaseCell= 10
For i = CurrentTable.StartY to CurrentTable.MaxY
For j = nIndexX to CurrentTable.MaxX-ncals
if CurrentTable.GetCell(j*ncals,i).value < nBaseCell then
for z = 0 to nCals-1
Before the cleaning script:
After with the cleaning script:
You can download the example 📥 here.