Erroring Forumla Updates on Table Controls

Ryan Miller

February 23, 2017 at 10:45 am #3814

I am having an issue with formulas used within my SPARK table control. I saw the issue is already raised in this forum in this question. I have not seen an update or bug fix in this 4.4.6 version, so I wanted to see if there is a workaround or alternative solution.

Basically, I want to add up all the decimal values on each row in my table.

SUM(${Table1/rowTotal1*})

The problem comes when I delete a row in my table. This action sets the SUM to 0, and prints this text to the console:

Error executing formula expression for view /Table1/row[1] (UID=517): this.context.binding is null

SPARK Support

February 23, 2017 at 12:38 pm #3817

Hi Ryan,

I have a test harness set up with this exact scenario.  I have tested both SUM(${/Table1/Income*}) and SUM(${Table1/Income*}) with SPARK versions 4.4.5-4.4.8 and I am unable to reproduce this error.

Can you attach a small standalone TWX to this post?  If the file is over 20MB, I will need to provide you with an upload directory.

Regards,

Stephen P.

Ryan Miller

February 23, 2017 at 1:19 pm #3818

Thanks for the reply. The issue is replicable when you delete a row that is not the first or last row. Please see the TWX I have attached that demonstrates this. Notice the sum total changes to a value of 0 and there is an error in the F12 console.

SPARK Support

February 23, 2017 at 2:37 pm #3821

Hi Ryan,

I have been able to reproduce this issue.  I notice, however, that if you set the Table configuration to Show Delete Button, using the built in delete does not produce this error.

I will review this with the Development Team and determine if this is a bug.

Regards,

Stephen P.

Ryan Miller

February 23, 2017 at 5:13 pm #3823

Thanks Stephen. Unfortunately that workaround will not be helpful in my situation.

My actual use case (as opposed to the simplified example I sent you) involves a button that re-populates the table with new query results when clicked. Each time the query is executed, I expect either the same or different number of rows to be returned to the table, and for the “Sum Total” field below to adjust accordingly.

…this use case involves financial data so it is highly important that the formula be reliable.

SPARK Support

February 24, 2017 at 2:06 pm #3837

Hi Ryan,

I did receive your ticket and responded earlier today.

I will update you via the ticket as I have more information.

Regards,

Stephen P.

Ryan Miller

November 1, 2017 at 10:00 am #4773

Hello. Was this ever resolved? If so, which version of Spark toolkit?

SPARK Support

November 2, 2017 at 9:25 am #4790

Hi Ryan,

This issue was addressed in the release of SPARK UI version 4.5.2 and BPM version 8.6 (CF201709).

Regards,

Stephen P.