The value entered does not match the format of the field

[Brittni_Schroeder]

I have seen this question posted on the forum, but I still am not sure how to resolve this issue.

This is my formula 

fg- Financial Goal

wov - Weeks of vacation

caw - Clients per week

(fg/(52-wov))/caw

Can someone please help me?  I need Adobe for dummies!

Thanks!

[John Waller]

Which Adobe software are you using?

[Brittni_Schroeder]

Adobe Acrobat Pro

[Test Screen Name]

If caw is not set, or wov is 52 (less likely), then you will be dividing by zero. This is an error. You need to use if statements to just not do the division in this case; you can't use simplified notation, it isn't up to the job.

[Brittni_Schroeder]

Can you give me an example of how I would use an if statement? Or direct me somewhere how to learn that?

[Brittni_Schroeder]

Would it look like this (fg/(52-wov))/caw;if (wov>52) wov=1

[gkaiseril]

No. you the possibility of 2 divisions by zero.. caw could be zero and wov could be 52. I would use something like:

event.value= "";
if(wov != 52 || caw !=0) {
event.value = (fg / (52 -wov)) / caw
}

Of course you will need to load the values into the variables. If wov or caw is conputed you may need to the try catch statements to trap divisors near zero. 

[Brittni_Schroeder]

I can not figure it out. Can you direct me to someone who I can pay to do it for me? It is just that one formula, but I can't get it to work.

[try67]

I can do it for you, for a small fee. You can contact me privately via [try6767 at gmail.com].