Summing columns on tables

Follow

Fraser Rush

26 January 2016 12:50

when you use a table, I noticed on the table tab, there is a 'sum' checkbox for columns.  I imagine this will sum the values of the column for each row.  If this is correct, how do I pick up this summed total.  I cannot find anything out about it on the forums or help wiki, so perhaps someone can advise please?

0

• 

  Permanently deleted user 27 January 2016 17:33

  Hi Fraser, 

  To select the summed total in the rating you will need to use the following: 

  [TableName_TableColumn_Total_Cover]

  In document just wrap it around with #'s as you would a formula. 

  Hope this helps. 

  Thanks

  Adam

  0

  Comment actions Permalink
• 

  Fraser Rush 28 January 2016 10:42

  Hi Adam, 

  Thanks for this, but I need this summed total, not for a rating reason, but for a validation reason.  

  The table is for listing items that have a value in excess of £5000.  I have another question 'Sum to Insure' and a validation rule:

  Items valued £5000 or more - the sum of these must be no more than the total sum insured figure.

  It doesn't seem possible to reference the sum of the table column in the limits tab on the Sum to Insure question and there isn't a way (or there doesn't seem to be a way) to do this validation on the table's column.  Is it possible to do this validation?

  Regards

   

  Fraser

  0

  Comment actions Permalink
• 

  Permanently deleted user 28 January 2016 11:16

  Hi Fraser, 

  You will not be able to do a live validation.  Instead you will need to use Rules to refer when this does not meet the specifications.

  Eg.

  IF

   ' if([TableName_TableColumn_Total_Cover]>[ContentsSI_Cover],1,0)'

  Equal to

  1

  Then

  Refer 'Valuables greater than Contents SI'

  Thanks

  Adam

  0

  Comment actions Permalink

Please sign in to leave a comment.