I want to create an Electrical Panel Schedule that will automatically calculate loads. I want to be able to keep any empty load sections with a dash and still get a value in the total area. I am using formula fields to accomplish but when I hit regnerate, I get ####. Any ideas? Please see attached dwg of a 3 phase panel schedule
Solved! Go to Solution.
Solved by leothebuilder. Go to Solution.
The formulas need a real number.....in your load calc you have a - (dash)
Change these to a number like 0 (zero) and the formula will work.
Thank you for your response. I was wondering if zero values could be represented with dashes instead of 0 and still get a calculated value?
No....as I mentioned, formulas need numbers, a dash (or any other such character) won't work.
The only way around this if you have a zero on a non-plot layer to make the formula work and leave the dash as a visual.
Should the dash need to be changed to a number, delete the dash and change the number from no plot to a plotting layer.
I had the same problem with the sum in the AutoCad table, but the first solution I tried was to fill the cells with zero, then it worked. A table full of zeros was not visually appealing, so I left the cells empty, but the “####” error problem appeared again.
My final solution was to leave the cell empty, and in the addition formula, add “+ 0” (plus zero), and the program ignored all the empty cells and added only the numbers. It took me quite a while to figure it out, but now every time I draw an electrical panel, the answers are given automatically, without changing layers.
Can't find what you're looking for? Ask the community or share your knowledge.