Constant sum matrix sum + total sum from both rows and columns

Hello Tom, do you have the Java Script for this particular action?

@TomG I’m doing something similar here except that I actually want to display the total and make it update each time the row total changes in my Matrix Question. Right now, the function only works when I leave the page and return to it. 

DO you have any suggestion on how I might fix this, so it update while on the page?

Use a keyup or input event handler.

Hi @MatthewM  I am trying to sum across all cells (Race x Ethnicity), and have it total a prior question.  In your non-JS solution, you create a custom validation.  I tried to replicate.  I can select in the first box the question of interest, but the second box forces me to select one of the cells (not shown, when I scroll down are the additional race*eth options, never question), not offering the question as a possibility, like you show in your example.   Any guidance?  Thank you!

@Joba - @KPKat’s post reminded me that I have a function that displays and calculates both row, column, and grand totals: csmAddTotals.

Hi @KPKat ,

Basically you need to switch the questions around in your custom validation.

The questions are not shown in previous example so it may not have been completely clear, but in my case Q10 is a text entry question and Q11 is a matrix. Although the custom validation that I shared the example of was set up inside Q11, you’ll see I selected Q10 in the menu. The formula I shared represents each cell from Q11 (the matrix question).

In your survey, you’ll need to select the prior question in the Custom Validation menu (not the matrix question), and write in the formula with the QIDs from each applicable cell in your matrix question.

I added optional validation to csmAddTotals - when it adds to the specified grand total, the next button is enabled, otherwise it is disabled. Demo and details at the link provided.