Can we have the ability to use _Cover in an If Statement for APs and Renewals.
Completed
It is currently available in First Premiums but not APs and Renewals.
This is most relevant when showing rates used for liability risks. If new wagerolls are added or increased for example in an AP we need the ability to display all the new figures. So for example.... IF([ClericalWageroll]=0,'',[ClericalRate])
-
Further to my message above, I thought it worth giving you a few examples:
## IF([ClericalWageroll]=0,'',[ClericalRate])## - Showing a rate if a wageroll is given (in FP and/or MTA)
##([Building_SI]*1.15m).ToString("C0")## - Showing a 15% uplift on sums insured (in FP and/or MTA)
##IF([Building_SI]=0,'Not Insured',[Building_SI]) - Show Not Insured if FP and/or MTA sum insured is £0.
This problem is now extremely urgent as we cannot create correct AP documents for ANY of our clients.
Thank you
-
Adam
This has been sitting here since February (and was raised on 3rd Jan as a ticket, then a question). I am now being chased by all our clients for correct AP documents that I simply cannot produce due to this issue. i have been told it is a feature request but to be honest, call it what you may, the documents just are not working as they should.
We are due to go live ourselves imminently but I am going to have to put a stop to this as I am not prepared to leave a system that produces the documents we need for a system that cannot produce the documents, and judging by the very slow and minimal responses to this ticket/question/feature will not be here any time soon.
it is extremely embarrassing that correct documents cannot be produced and is not acceptable. we cannot have documents issued giving the incorrect sums insured, it is just not on.
Please can someone look at this again as a matter of urgency. there is no point in waiting for people to vote on this as our clients would not have a clue what we are talking about as they do not produce their own documents. you will just have to imagine that all our clients that have logins have voted "Yes" to this request.
please come back to me.... preferably by tomorrow. I have clients waiting to send out MTA documents that are incorrect !
So you can see this history of this:
Ticket (raised 3rd Jan) = #3555
Question (raised 2nd Feb) = Using _Cover within IF statements on Adjustment documents
Thanks
-
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.
-
Rob, you are my hero. Absolute genius !!!
I shall be giving this a go this afternoon. Thank you ever so much. Sorry if I was sounding a bit angry before, I was just frustrated. We have been asking about this for months and didn't think it was possible.
Thanks again
By the way, is this a new thing or has Policy_ always been available ?
Please sign in to leave a comment.
Comments
8 comments