Using _Cover within IF statements on Adjustment documents

Follow

Mark Williams

02 February 2012 11:23

We are having trouble using the _Cover in Adjustment Documents. It seems to work fine if we add a calculation question to the document on it's own but not if included in an if statement. Example as follows:

The Buildings_Cover of the original policy is £100,000

The buildings_Cover of the Adjustment is £150,000 (£50,000 difference)

Adding [Buildings_Cover] to the adjustment document will show £150,000

Adding ## IF([Buildings_Cover]=0,'Not Insured',[Buildings_Cover].ToString("C0")) ## to the document produces a result of "Not Insured" regardless of the Buildings_Cover.

If anyone could throw any light on this please let me know.

Best regards,

Mark

0

• 

  Peter Crowhurst OLD 03 February 2012 12:37

  Hi Mark,

   

  Is the field name just Buildings ? or the whole field name Buildings_Cover ?

  
  

  If you have a question  B_SI

  
  

  and for a First Premium B_SI = 10000

  and for an adjustement the B_SI = 6000

  
  

  on a Document for the adjustment

  [B_SI] would display 16000

  and

  ##[B_SI]## would display 6000 (the value of the Adjustment)

  0

  Comment actions Permalink
• 

  Mark Williams 03 February 2012 13:00

  Thanks for that Pete but it does not entirely answer the question.

  I need to be able to ascertain the total SI within an IF statement (The original plus any adjustments) as shows when used outside of an IF statement. I need this because even if there is no change, I still need to show the total as per my example:

  ## IF([Buildings_Cover]=0,'Not Insured',[Buildings_Cover].ToString("C0")) ##

  Cheers.

  Mark

  0

  Comment actions Permalink
• 

  Peter Crowhurst OLD 03 February 2012 13:14

  Mark,

   

  Currently I do not believe it can be done within the ####

   

  regards

   

  Peter

  0

  Comment actions Permalink
• 

  Mark Williams 03 February 2012 13:56

  Thanks Pete.

  Shall I raise this as a feature request or ticket?

  Are there any plans to make this work?

  Cheers.

  Mark

  0

  Comment actions Permalink
• 

  Colin Kippin 03 February 2012 14:37

  Hi Mark,

  This should not be a ticket as it is not a bug, its the way that the MTA and IF Statements operate at present.

  If you would like to put this on the Feature Requests hopefully it will get voted on and will move up the development list.

  Regards

  Colin

   

  0

  Comment actions Permalink
• 

  Rob Symonds 20 August 2012 09:25

  Hi,

  Any answers that appear on the Matrix tab (Calculation type answers) store the CHANGES to the question at MTA.

  Therefore, on an MTA, when you use ## [QuestionName_Cover] ## you have access to the DIFFERENCE in cover for that answer.

  To get the amount for that POLICY all you need to do is prefix the token with "Policy_"

  So, 

  ##IF([Building_SI_Cover]=0,'Not Insured',[Building_SI_Cover]) ##

  Becomes:

  ##IF([Policy_Building_SI_Cover]=0,'Not Insured',[Policy_Building_SI_Cover]) ##

  Thanks,

  Rob.

  0

  Comment actions Permalink

Please sign in to leave a comment.