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

Question

Question

FX Function within table calculating values within a column and using using the values in same column

Forms
Updated September 25, 2020
asked on September 19, 2020 • Show version history

Hi,

In  table 2, i have a column name No of Items, using IF, Row 1 is equal to Table 1.Number of entities,1 and then Table2 no of items row 5 should be the sum of table 2 no of items row 2,3 and 4. Below is the function i tried using, but it is not working. I have also tried to create separate fields to do the calculation in and out of the table, but it errors out and shows circular reference.

=IF(ROW()=1,SUM(INDEX(Table1.Number_of_entities,1)),IF(ROW()=5,SUM(INDEX(Table2.No_of_items,2),INDEX(Table2.No_of_items,3),INDEX(Table2.No_of_items,4)),0))

Any thing else i could possibly try?

0 0

Answer

SELECTED ANSWER
replied on September 22, 2020

What version of Forms are you using? If you are using Forms 10.4.3 or before, you should be able to get the value even it shows there is circular reference error.

0 0
replied on September 25, 2020

Hi Xiuhong, we are still on forms 10.4.0.1256. I resolved this issue with Java Scripting doing the calculations.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...