Summing columns on tables

Comments

3 comments

  • Avatar
    Adam MacDonald

    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

  • Avatar
    Fraser Rush

    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

  • Avatar
    Adam MacDonald

    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

Please sign in to leave a comment.