I've reviewed the "Calculated Fields Reference Guide" and done some searching on the topic to no avail. I am trying to create a read-only field with a calculated value based on a calculated entry in another field. Like this:
Field3 provides the sum of Field1 - Field2
So if Field1 has an entry of "100" and Field2 has an entry of "25" Field3 will calculate 100 - 25 = 75. Simple math. No problem.
I now want to use that result to calculate another field. Like this:
{{newInfo_es_:calc(if(Field3<100,5,15))}}
That also works, no problem. Since in the above example Field3 = 75 the result in newInfo is "5".
The problem occurs when I try to calculate based on the following logic:
IF Field3 = 0 THEN newInfo = 0
IF Field3 > 0 AND < 100 THEN newInfo = 5
IF Field3 > 99 AND < 150 THEN newInfo = 10
ELSE newInfo = 15
Here is how I wrote the calculation, which Adobe Sign does not like:
{{!newInfo_es_:calc(=if(Field3=0,0,if(and(Field3>0,Field3<100),5,if(and(Field3>99,Field3<150),10,15)))}}
This was actually TOO much for the area in the document where I wanted it, so I also used reference tags like this:
{{$NEW}}
{{#NEW=!newInfo_es_:calc(=if(Field3=0,0,if(and(Field3>0,Field3<100),5,if(and(Field3>99,Field3<150),10,15)))}}
The result was when uploading into my Adobe Sign library, and then opening it, it called this whole thing out as an error. I am going to go back in, and remove the reference to see if that is part of the problem, to see if the calculation works -- but since I couldn't find any instructions regarding nesting IF and AND statements, I am guessing that is the issue.
Any helpful feedback from someone who has accomplished this would be very much appreciated.
Thanks!
DAVID
AdChoices