field/formula attribute per visibility state in a block attribute table

[MarkVerbs]

Hello again,

I'm not sure if this is a dynamic block question or a data extraction one.

I have multiple visibility states and a different attribute formula for each one. The geometry is all similar per state, and the formulas based off of the same said geometry. I tried individual attributes per visibility layers but that doesn't isolate to extracting only visible attributes. The problem I am having is that I need to extract that specific attribute pertaining to what is visible in the whole drawing. In another block I have made it was possible to do so through the block attribute table but that did not have any formulas.

I am not sure I have stated my problem clearly but have tried. If you can help and need more information please ask as it is hard for me to describe.

Thank You

[MMcCall402]

Can you give us a little more info and/or a visual of what you're working one.  (posting the block would be great)

I'm wondering if there might be some way to have a single attribute and alter the formula values thru a block table and user parameter(s).

[MarkVerbs]

Sorry I brain farted. The block is for an irrigation head. I will break a group of heads into zones via layers.

I will have a fair number of these blocks per layer. Each head can have a different attribute number pertaining to the gallons/minute it requires due to the area it will cover. Each visibility layer is for the different size heads available, and has a different formula to calculate the gpm as you can see in the attributes I tried to use. I have to total up the gpm attribute per layer to have a total gpm per zone(layer).

I want to do a data extract to show how many heads are per zone, and what each gpm is per head, then total the gpm/ zone.

I really don't want to have to manually enter in the gpm per head into a table.

.

[MMcCall402]

The formulas are a little more complex than I was expecting but I have an idea.  I was thinking to introduce a new value into each formula, one that could be controlled by the block table, and use it to cause them to either calculate to their intended value or 0.  (like introduce a value of *1 or *0)  Then, add a new attribute that would add up all the gpm values.  The block table would only supply 1 to the chosen item and 0 to the others such the the chose item's gpm formula would calculate a value other than 0.

[MarkVerbs]

The adding up of gpm can be done in a data extraction. I don’t have to have it in the block, hadn’t thought of having it there but it could be cool but not fully needed. I just have to have the attribute extracted clearly which is why I’m trying to get it set in the block correctly to do that. If I extract the gpm for one zone it will currently give me ALL of the gpm’s per head even if not on visibility layer.

[MMcCall402]

Adding up the gpm of all the heads within the block and producing it as one attribute, yet it being only the GPM of the selected head was what I was going for. The additional multiplier values would turn all but the selected head's gpm formulas to 0.  That should then make the block's overall gpm attribute only show the gpm value for the selected head, and make this value available for the data extraction where it can be tabled and totaled.

[MarkVerbs]

I think I understand now. I'm not sure how to put a formula or Boolean(if statement) in a block table. Is it even possible?

[MarkVerbs]

You gave me an idea and I am working on trying to put it into action. I am going to try to make one attribute with a formula of fields referencing the block property table. I'll have to get back with you after I try.

[MarkVerbs · Accepted solution]

Okay, I have resolved the issue except I need the result to be only 2 decimal places. I cant seem to get the round(XX,2) thing to work.  Do I need to post this in a different thread?

[MMcCall402]

Try (Round(XX*100))/100

[MarkVerbs]

So I tried that, and it does give a 2 decimal place (not sure how that works) but it messes up the formulas and comes up with the wrong calcs. If I do not do the rounding, I have the correct number but with 4-5 decimal places, which is too many. Any ideas how to fix that?