Comments

4 comments

  • Hi Jon!

    You can use XXX_DateValue to get a date value for comparison.

    e.g.
    IF([Person1DOB_DateValue] > [Person2DOB_DateValue], Person1_Younger, Person2_Younger)

    Hope that helps.

    0
    Comment actions Permalink
  • Avatar
    Jon Collis

    Hi Rob,

    Hope you and your family are well.

    I’m not quite sure how to put that in my matrix, I currently have this:-

    "YearDiff:InsuredOneDOB","SetCover:ICInsuredAge" 
    "1-29.99","1.20" 
    "30-40.99","1.00" 
    "41-50.99","0.90" 
    "51-59.99","0.85" 
    "60-99.99","0.80"

    The above is only doing Insured One and ignores Insured Two, how would I merge your suggestion into this?

    0
    Comment actions Permalink
  • All good thanks Jon, busy :o)

    Hope you're fine and dandy as well.

    Here's what I'd do - keep it as transparent as possible (and do what you want)

    Add two extra questions to hold the individual rates, say InsuredOneCost and InsuredTwoCost, then set ICInsuredAge to the higher of the two rates:

    "YearDiff:InsuredOneDOB","SetCover:InsuredOneCost"
    "1-29.99","1.20"
    "30-40.99","1.00"
    "41-50.99","0.90"
    "51-59.99","0.85"
    "60-99.99","0.80"
    ###
    "YearDiff:InsuredTwoDOB","SetCover:InsuredTwoCost"
    "1-29.99","1.20"
    "30-40.99","1.00"
    "41-50.99","0.90"
    "51-59.99","0.85"
    "60-99.99","0.80"
    ###
    SetCover:ICInsuredAge
    IF([InsuredOneCost_Cover] > [InsuredTwoCost_Cover], [InsuredOneCost_Cover], [InsuredTwoCost_Cover])

    0
    Comment actions Permalink
  • Avatar
    Jon Collis

    Thanks Rob, it works perfectly.

    0
    Comment actions Permalink

Please sign in to leave a comment.