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
dim i'rows
For i = CurrentTable.StartY to CurrentTable.MaxY
dim j'columns
For j = nIndexX to CurrentTable.MaxX-ncals
if CurrentTable.GetCell(j*ncals,i).value < nBaseCell then
dim z
for z = 0 to nCals-1
CurrentTable.getCell((j*ncals)+z,i).setText("-")
next z
endif
next j
next i
Before the cleaning script:
After with the cleaning script:
You can download the example 📥 here.