I have a dynamic block but the actual part which isn't dynamic seems to be causing the problem. It's a manhole schedule and through a series of forumlas eithin attributes it works out pipe invert etc
I have a row (see below) which works out the pipe invert for me based on the pipe diameter which is typed in the column on the right. When no pipe Dia is typed in the default #### is displayed but once the Dia is added it inserts the value. The problem I have is that when no pipe dia is typed in it still shows #### as the default value even though there is no value there. I can have hundreds of these schedules in a drawing each with different number of pipes going in and out so I don't want to have to delete the #### in case I need to insert it later.
You can see the top three rows are being used (PIPE REF A, B & C) But the rows beneath are blank for this one but the #### is still showing.
Is there a way to hide the default #### from being displayed from the formula within the attribute?