Answers/SchemeServe Answers
Answered
Using _Cover within IF statements on Adjustment documents
Mark Williams
asked this on Feb 02 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
Comments
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)
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
Mark,
Currently I do not believe it can be done within the ####
regards
Peter
Thanks Pete.
Shall I raise this as a feature request or ticket?
Are there any plans to make this work?
Cheers.
Mark
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