Drop Down Box Calculations

asked on January 24, 2024 • Show version history

I was wondering if anyone has ever done a calculation based off of multiple drop down boxes?

I am trying to create an employee evalution form, and there are multiple sections where the employee and supervisor need to "select" a number based on a scale 0-6.

there are a total of 6 different drop downs, so I would like to sum up what was selected and put the final "total" in a Overall box at the bottom. I made it so that each drop down choice has a value assigned to it....but I am not able to figure out how to get that value to total in the other box. Any insight would be great.

The picture is showing an example where I would like the Employee Rating (2-Meets) will SUM in the Overall Employee Rating box. Also the other one is how I have my drop down setup.

example.PNG (21.59 KB)

| Download

choices.PNG (8.77 KB)

| Download

0 0

replied on January 24, 2024

My first try was the simple =SUM(employee_focus + employee_peer) etc... with no luck

My Overall "fields" are number so they should be able to do calculations

I was a loss on where to actual do the addition w/ the values vs. just the choice.

Haven't ever tried it.

0 0

View 7 previous replies

replied on January 24, 2024 • Show version history

If that's actually how you wrote it, then the syntax of your formula is incorrect. As you can see here (Formulas in Laserfiche Forms), the formula should be:

=SUM(value1, value2)

Since your values are not a number field, it may also help to convert them to number values as well:

=SUM(VALUE(value1), VALUE(value2))

I would also advise against using "Rating" as some kind of placeholder option in the dropdown since it is not a valid option or value.

1 0

replied on January 25, 2024

So here is the new test I tried....

=SUM(VALUE(Employee_CustomerFocus), VALUE(Employee_Funtional), VALUE(Employee_Quality), VALUE(Employee_Productive), VALUE(Employee_Peer), VALUE(Employee_Action))

And still getting a calculation error.

Thank you for the Link to the formulas! I had it at one time and lost it!

0 0

replied on January 25, 2024 • Show version history

Is there a typo in your variable? "VALUE(Employee_Funtional)"

0 0

replied on January 25, 2024

There was! I went through and redid them. And still no go. I can get it to display a "0" now in the box but it will not "sum" them.

My most current syntax is....

=SUM("VALUE(Employee_CustomerFocus)", "VALUE(Employee_Functional)", "VALUE(Employee_Quality)", "VALUE(Employee_Productive)", "VALUE(Employee_Peer)", "VALUE(Employee_Action)")

I am wondering if this is even possible to do this? Or if anyone has ever tried it before.

My "Overall Employee-Rating" where I want the final calculation put is a number field.

0 0

replied on January 25, 2024

I also did remove the "rating" option from the drop down so it all numbers. I also removed the "values" from the drop down...

0 0

replied on January 25, 2024

I just realized I probably missed an important piece....I created sections for each of the "topics". I can easily add the an employee & supervisor rating in 1 section, however I am not able to add those through to other sections.

0 0

replied on January 25, 2024

And I am starting to really notice that the
=Value does not like any of the options that have "words" in them...

so it will transfer 1, but not 2 - Meets

0 0

replied on January 25, 2024

The sections should have no bearing on the calculations. VALUE is used to tell the variable to be treated like a number, so if a 2 was to be in a string field, VALUE means to treat that 2 as a number, and not a letter per say. VALUE does not convert an alphanumeric string to a number such as “2 - Meet”, in that case you would need to pull the number from the string first and then tell use VALUE to treat the result as a number. Such as =VALUE(LEFT(“2 - Meet”,1)) would return a Value of 2.

in this formula you had posted, =SUM("VALUE(Employee_CustomerFocus)", "VALUE(Employee_Functional)", "VALUE(Employee_Quality)", "VALUE(Employee_Productive)", "VALUE(Employee_Peer)", "VALUE(Employee_Action)")

there should be no “ as that tells the formula that what appears between the quotes to treat as a string, and therefore the system doesn’t see these as functions or variables.

2 0

replied on January 26, 2024

Wow - Thank you so much!! This is helpful and will give it a shot!!

0 0

replied on January 26, 2024

Steve - Thank you!!! I have it working. In the end this is what it looks like. So I had to double count all the "parenthesis" to make sure I had counted for!

=SUM((VALUE(LEFT(Supervisor_CustomerFocus,1))),

(VALUE(LEFT(Supervisor _Functional,1))),

(VALUE(LEFT(Supervisor _Quality,1))),

(VALUE(LEFT(Supervisor _Productive,1))),

(VALUE(LEFT(Supervisor _Peer,1))),

(VALUE(LEFT(Supervisor _Action,1))))

0 0

Question

Question

Replies

Sign in to reply to this post.