Panel Schedule Template formatting of Calculated Values

[dtiemeyer]

When I use a <parameter> to define a value in a panel schedule template, the result is 'blank' until data exists to populate it. But if I use a calculated value to define a value, it defaults to '0' instead of 'blank', thus causing my rows to look different. Any way to make this act the same?  I'm attaching an image and a v12 model. Thanks!

Dustin

[CoreyDaun]

Would it be plausible to just change the direct Parameter References into Calculated Values to make it display consistently? For example, in lieu of just linking "K Connected" to a cell, create a Calculated Value with the formula "= K Connected"?

[David_Robison]

In my add-in, I ran into a similar problem. My was a little different--for a numeric parameter, it is blank until you give it a value, and then always has a value. There's no way to go back to blank.

I ended up choosing to use string parameters and do the conversion from a number to a string manually. That allowed me to also use a blank string when I wanted it to not have a value.

I'm not sure if it is possible or not, but can you use strings as your final output instead of a number? I haven't done much work with panel schedules or calculated values. If you can embed just a little bit of logic in the calculated value (a basic if-then) you should be able to make it work.

Otherwise, I would go for a solution similar to what Corey suggested, where they are all calculated values and all display a 0. Otherwise I think you'll run into cases where you can't get the parameter back to be blank after filling in a value.