<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version rmj.rmm.rup.rpr">
<TITLE>adding values in a custom calculation script</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial">Hi, I</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT FACE="Arial">hope someone can help me with my question. I am creating an interactive Pdf file and</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT FACE="Arial">have created a custom calculation script to calculate</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> the</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT FACE="Arial">“</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial">difference</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial">”</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> in some fields</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> within my file</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> eg Text 1 – Text 2</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Arial">However, when</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> I go to sum these values into a separate Summary Table, the values do not calculate correctly.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> It seems that the sum function in Scribus does not see these values as a fixed number, but as a formula and continues to add/deduct them from the overall total.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT FACE="Arial"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Arial">Has anyone had this problem before and any ideas on how to fix it?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Arial">Below is an example of my custom calculation script.</FONT></SPAN><SPAN LANG="en-au"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-au"> </SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Calibri">var v1=getField("TotalBudgetEstimate2").value;var v2=getField("TotalQuotedPrice2").value;event.value=v2-v1</FONT></SPAN><SPAN LANG="en-au"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Calibri">Thankyou</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"><FONT FACE="Calibri">Georgia</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
</BODY>
</HTML>