Help me please before I lose my mind 😂

Question

Hi,

I was wondering if anyone could help. I am trying to create a formula that pulls through on to the attached.

I need the monthly payment amounts to calculate based on different rates. As per the table at the bottom of the document. This is based on the dropdown selected. This would then need to follow with a calculation of Cost*thefield/100.

Are you able to help?

Cheers

Chris

Nesa Nurani · Accepted Answer

Nesa, I am so sorry to be a pain. I am struggling again with the calculation for the Tax Relief and Net Cost After Tax Relief parts of the documents. I have tried using simplified but this is not working.

Tax Relief

I need the below to calculate.

2year_Weekly*104 then I need the box to show 20% of the value calculated

3year_Weekly*156 then I need the box to show 20% of the value calculated

4year_Weekly*208 then I need the box to show 20% of the value calculated

5year_Weekly*260 then I need the box to show 20% of the value calculated

Net Cost After Tax Relief

This is just Tax Relief - Cost

Im so sorry to keep pestering you. I really appreciate your help.

Cheers

Chris

Simplified field notations are 'sensitive' to field names, which can't start with a number, contain space character...etc, you need to escape it with a backslash, and to show 20% multiply result by 0.2, try this as simplified field notation: \2year_Weekly*104*0.2

PDF Automation Station · Answer

First, remove all your simplified field notations. They have errors. Next, change the export value of "New Business Under £5K+VAT" in the dropdown from 1000 to 1. This is script a custom calculation script for the 2-year monthly payment field. You will have to modify it for the other monthly payment fields:

var type=this.getField("Business_Type").value;
var cost=this.getField("Cost").value;
if(type==1)
{event.value=this.getField("NewStartU52Y").value*cost/1000;}
else if(type==2)
{event.value=this.getField("NewStartO52Y").value*cost/1000;}
else if(type==3)
{event.value=this.getField("EstU52Y").value*cost/1000;}
else if(type==4)
{event.value=this.getField("EstO52Y").value*cost/1000;}
else
{event.value=""}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded