Answers/SchemeServe Answers

Answered

Table Total validation

Paul Taylor
asked this on June 07, 2011 05: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
 

Comments

User photo
Colin Kippin
ADM Network Ltd

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

 

June 07, 2011 11:12
User photo
Paul Taylor

Hi Colin,

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

Cheers

Paul

June 22, 2011 12:38
User photo
Rob Symonds
ADM Network Ltd
Ajax_loader_small Answer

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.

June 22, 2011 12:53
Add a comment