Question

Calculating from table drop downs

Forms

Updated June 7, 2018

asked on June 6, 2018 • Show version history

Hello,

I having trouble getting a calculation to work in a table. Please see the screen shot. I have a table for each week of each month on the form. Users need to select their work and vacation days for the coming year in the drop down for each weekday. The first value in the dropdown is W for Work, and the second is for V for Vacation. Both W and V have 1 as their corresponding values. (The value for V is versioned to 1_1 since W is already 1, and I'm not sure if this is affecting the calculation)

Without doing anything fancy, I can get the Work Day Totals field to calculate properly using this: =SUM(July_Week_1.Monday,July_Week_1.Tuesday,July_Week_1.Wednesday,July_Week_1.Thursday,July_Week_1.Friday)

But I've tried several different methods on the Vacation Day Total field to no avail. I'm not sure if the advanced setting formula or some javascript would be better suited for this.

One of options that I've tried is SUMIF(July_Week_1.Monday,July_Week_1.Tuesday,July_Week_1.Wednesday,July_Week_1.Thursday,July_Week_1.Friday) returns "V") but this give be the calculation error notification.

Any help is greatly appreciated.

Thanks,

Brian

Table Calc.PNG (33.51 KB)

| Download

0 0

Replies

replied on June 6, 2018 • Show version history

If you are assigning values to the drop downs, the value could be seen as a string rather than a number??

Try wrapping your value in the FIXED function or other:

The FIXED function returns a number based on a specific number of significant digits.

"=FIXED(3.141592, 3)" returns "3.142"

I hastily looked through the list in the help file.

Hope this helps or leads to the answer.

0 0

replied on June 7, 2018

This issue just got more interesting because if there are values assigned to the items in the drop down, if the number is not unique to this value list, it will not calculate. This is a problem because both the W and V values for Work and Vacation days equal 1. Seems like javascript maybe necessary for this particular use case.

0 0

You are not allowed to follow up in this post.

Question

Question

Calculating from table drop downs

Replies

Sign in to reply to this post.