Update fields controlled by formulas when updating a table

Emil Brolin

February 24, 2017 at 3:10 am #3828

I have a scenario where I have a table with three columns. Num1, Num2 and Total. Total is populated with a formula that sums Num1 and Num2.
Outside of the table I have a decimal CV that should show the total sum of Total. The Table is paginated so I use SUM(${Table1}, FOR_EACH{#{sum1} + #{sum2}}).

I manage to update the Total-column when I change a value in Num1 or Num2 by having me.ui.getSibling(“Tabell1”).refresh(); in each of the columns OnChange-events. It also updates one field outside the table wher I don’t consider the pagination SUM(${Table1/Total*}).

How do I update the value of the field where we do want to consider the pagination when we update a value in the table?

SPARK Support

February 24, 2017 at 2:59 pm #3839

Hi Emil,

I need more information to understand the question.  Perhaps it would be helpful to see a screenshot of the configuration.

I see that you mention one field using SUM(${Table1}, FOR_EACH{#{sum1} + #{sum2}}). vs another field using SUM(${Table1/Total*}).  Are you looking to SUM only the amounts on one page?

Regards,

Stephen P.

 

Emil Brolin

February 26, 2017 at 11:27 pm #3848

Hi!

I want to sum the total(s) of all pages when the table is paginated. I manage to do that with SUM(${Table1}, FOR_EACH{#{sum1} + #{sum2}}), but then I cannot update SUM of Total when a value in the table is updated by the user. So I somehow need to refresh the table and the SUM of Total when the table is updated.

SPARK Support

February 27, 2017 at 1:06 pm #3866

Hi Emil,

I was able to replicate this issue with the For Each SUM not being updated upon value changes.  A fix will be released for this issue in an upcoming release.

Regards,

Stephen P.