Question

Form Excel Calculations

Forms

Updated March 5, 2020

asked on March 4, 2020

Has anybody seen this before.
I am trying to calculate values across columns in a table using an excel calculation.
The first calculation works fine but when I add a new row the calculated column multiplies itself with the calculated column in the next row.

My formula i am using is

=SUM(INDEX(Supplier_Allocations.Jan,ROW()),INDEX(Supplier_Allocations.Feb,ROW()))

0 0

Replies

replied on March 5, 2020

Everything looks good here...

I used the following calculation in the Allocated column and didn't see this multiplying issue. I used a currency field set to ZAR as well. I didn't change my locale to use , decimal separator however.

=SUM(INDEX(Table.Jan,ROW()),INDEX(Table.Feb,ROW()))

Do you have any other details about how to reproduce this? If you test it with number fields, does that work?

Are there any other calculations, default values or lookups in play here? Does adding another row to the table help? You might need to open a support case so we can take a look at your process specifically.

0 0

replied on March 5, 2020

Hi Jared.

I tested with numeric fields as well and got the same result. I have tested this on 3 different computers and all got the same result.

No default values have been added.

What forms version are you using? I am using 10.4.1

0 0

replied on March 5, 2020 • Show version history

I was on the latest 10.4.3. Let me see if there's a bug from that version you might be hitting.

0 0

replied on March 5, 2020

Hi David,

I'm not able to reproduce your issue on Forms 10.4.1.164, can you open a support case for it when you have time? Please provide the following information in the case:

1. The exact version of Forms, including build number

2. The business process used to reproduce your issue

3. A short video to reproduce the issue

Regards

0 0

replied on March 5, 2020

Hi Zhiyong,

I have logged a support call & added all the required information.
The forms build is Professional Version 10.4.1.164.

Case number 208150

0 0

You are not allowed to follow up in this post.

Question

Question

Form Excel Calculations

Replies

Sign in to reply to this post.