Hi - I am creating a retirement investment report and want to use a summary using merge tags on the reports.
The form is here; https://www.noallco.com.au/retirement-calculator-2/
In order to give a final figure both on the form and on the reports It uses conditional logic to show a field based on the amount of time until retirement. This brings an issue though!
The merge tag on the confirmation is: “Your end balance on retirement will be: {Amount at retirement:67} against your target of {Desired annual income at retirement (today’s dollars) ($):10} per year.”
The trouble is the {Amount at retirement:67} field could be any one of 50 depending on which is showing. Is there a way to pull the data from the one field showing?