Pat Dixon

That helped, thanks.  Would it make sense to have a trim or clamp function to make this easier?  All I want to do is to remove data outside of a range, and it seems you have to go pretty deep to get that to work

This is not working for me.  Remove is not removing data, it is keeping the last value.  This messes up formulas.

I doesn't appear to matter how many tags are used.  With only 12 tags in the worksheet I get the same error

I tried rebuilding it in a new worksheet, but when I got to 47 tags in the sheet this happened.  I did exactly the same scorecard metric for every one of these tags, only with a different item to measure.  It looks like Seeq just cannot handle too many tags.

I have developed a lot of worksheets and organizers (reports) for a client that are working very well, but there is one I just created that is extremely sluggish.  Attached are images of what I am building.  Do I simply have too many tags?  All the other worksheets I created work fine, but on this one I get a lot of waiting for the hour glass and the display takes a long time to render when I change anything.

 

The problems seems to be the New Batch formula.  The purpose is to create capsules only when the Seq_ID changes.  You can see the trend of the Seq_ID in the trend.