Table Total validation

Follow

Paul Taylor

07 June 2011 04:35

Hi Guys,

I've got the following scenario:

A question-page has a cover amount which when populated loads a conditional page. Basically, the cover amount is the total sum-insured for a particular section, adn the condition-page requires entry (in a table) of the items that make up the sum-insured.

So for example, I might enter a sum-insured of 20,000, and then on the table-page I enter items.

I want to display a warning message, or a referral (don't mind which) if the sum of the items in the table doesn't equal the sum-insured on the previous page.

Within the rule-builder the "Table Column Total" entry doesn't seem to allow a comparison with another field, just a constant value.

How can I get around this?

Thanks

Paul

4

• 

  Colin Kippin 07 June 2011 10:12

  Hi Paul,

  I don't think you can do comparison of fields in the rule builder.

  Rob will pick this up when he returns from holiday but as I say I am pretty sure you cannot do this.

  Colin

   

  0

  Comment actions Permalink
• 

  Paul Taylor 22 June 2011 11:38

  Hi Colin,

  Is Rob back yet from his holidays to look at this one?

  Cheers

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 22 June 2011 11:53

  Hi,

  I think you'll have to set a hidden question in the Conditional Rate File and test that in the Rule Builder.

  Something like:
  ###
  SetCover:ItemsToTotalRatio
  [TotalQuestion] / [TableColumn_Total]

  ###

  You can then test "ItemsToTotalRatio" != 1 in the Rule Builder.

  Does that help?

  Thanks,

  Rob.

  0

  Comment actions Permalink

Please sign in to leave a comment.