Calculating with yes\no parameter

[DFcheee]

I have extract area information from my project and I want to totalize some of it. I have created different Yes/No Parameters for those I want to calculate. My question is how to do it, or whats the formula for it. 

[XXalessio.amodioXX]

Sort by Yes parameter>Ground totals>Area calculate totals

[TripleM-Dev.net]

Hi,

You created "Different" yes/no parameters? Does this mean multiple yes/no or just one with different values?

Which condition should be evaluated?

You can simply filter out the elements in the schedule itself, unless it's more than 8 or needs a "OR" compare and not "AND", then you could use a Calculated Field and filter based on that result.

Maybe post a image of a schedule with the parameters/values and the desired elements marked?

- Michel

[DFcheee]

still not calculating it right 

I wanna collect the one mark with yes in the last column 

[TripleM-Dev.net · Accepted solution]

Hi, I assume you don't want to filter out all values? otherwise it would be easy, just apply the yes/no parameter in the schedule filter.

To keep all values and only count area's of Yes in a specific Yes/No column.

Use a Calculated value field to "duplicate" only desired values to a calculating column (Area3 in this case)

See the formula in the Calculated value.

Endresult, only desired area's are "duplicated" in the Area3 column

First add a Calculated value

Set the new field to Calculate totals

And setup the Sorting/Grouping/Headers etc

[XXalessio.amodioXX]

Hi,

You have 3 Yes/No parameters.

-First assign the grey out parameter (Are they Yes or No?)

-Second wich one of Yes/No parameter you want to sort?

[DFcheee]

Thank you very much! 
xoxo

Val 

[TripleM-Dev.net]

@XXalessio.amodioXX , the "grey" values (uninitialized parameters) shouldn't be a problem as long as you only want to filter on Yes OR no. If both values have to be accounted for, all should have a value, that's correct.

@DFcheee wants the last column to be used, although the first marked area value doesn't have a Yes associated in the last YesNo column, so..?

- Michel

[DFcheee]

Darling, dont hate the blond woman :D, but is there a chance you could know how to divide the total I got from this exercise to the one highlight in green value I didnt add in calculation, the top one. If its not to much to ask about. 

[TripleM-Dev.net]

Uhm, maybe I'm getting blond...I need some more info

You want the Sum of the Green fields in A to be divided by the B value?

That's possible, but I would need a unique identifier for the field, and has to be a number or YesNo parameter?

[DFcheee]

You want the Sum of the Green fields in A to be divided by the B value? - Thats exactly what I want. Not sure which is better, the number or yes\no, but I do believe that y\n will work for me.  

[TripleM-Dev.net]

Small correction, pointed out the wrong button for adding a Calculated value.

Seems can't get the Divide calculation going, the divide by 0 gives problems.

In the past with percentages I could work around it, I can't seem to get it working for numbers

- Michel