You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Forms PRODUCT Calculation Error

Forms Version 10
Updated May 19, 2021
posted on May 19, 2021

Hello,

I have tried doing a row calculation for the following.  Variables Total and Rate/HR are numbers with decimal of 2 the # of hours is number with no decimal.

=PRODUCT(INDEX(Facilities___Personnel_Charges.V___of_Hours,ROW()),INDEX(Facilities___Personnel_Charges.Rate_Hr__,ROW()))

Keep getting calculation error on the form.

What am I missing??

Thanks!!  Sue

0 0
replied on May 19, 2021

It's a beautiful thing when things work LOL.  Naming of variable was the culprit!!  Thanks again for the quick response.  And I am using 10.4 :)  

0 0
replied on May 19, 2021

Hmmm.  OK I will double check.  I thought I used the picker but will double check them all.  Thanks so much.  Will let you know.

0 0
replied on May 19, 2021

Which version of Forms are you running, and are you sure all the variable names match exactly? I recreated your table in a test form the calculation worked fine.

First thing I'd check is that the variables in your formula actually match the variables in those columns, especially since one in the calculation has that V at the beginning that seems out of place.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...