Newbie Questions

Re: How to calculating percentage correctly?

Matt Faus — Mon, 09 Apr 2007 23:40:00 GMT

Hi Marina,

I played around with this a little bit and it looks like all of the calculations are happening as they should. I couldn't reproduce any rounding errors. Could you reproduce the situation in a simple form and mail it to me?

You could rethink your rounding assumptions, or try to cook up a crazy default value formula using the modulus of the sum of previous siblings to implementing rounding manually.

Hope this helps!

Re: How to calculating percentage correctly?

marina — Mon, 09 Apr 2007 20:42:13 GMT

correction:

if Sum(Line_charge)>InvoiceAmount
add to LastRow(Line_charge) $0.01

Re: How to calculating percentage correctly?

marina — Mon, 09 Apr 2007 20:38:56 GMT

Aruna, thank you for your reply. But, I am looking more for a solution such as:

Sum(Line_charge)
if the line_charge>InvoiceAmount
add to LastRow(Line_charge) $0.01

Thanks.

Re: How to calculating percentage correctly?

Aruna — Mon, 09 Apr 2007 05:58:36 GMT

Hi marina,

1.Double click on 'Line Charge (read-only)' field.
2.Click on 'Format' button under Data tab.
3.Change the decimal places to '3' and click 'Ok'.
4.Now enter
InvoiceAmount:$5.29, select Department, enter Percentage:50 and check Line charge.
5.It displays as '$2.645'.(Now the total upto $5.29)

Hope this helps you!

How to calculating percentage correctly?

marina — Sat, 07 Apr 2007 20:44:25 GMT

FORM FIELDS:
InvoiceAmount: (Example-)$5.29

Repeating table fields:
Department (drop-down): (Example-marketing)
Line charge (read-only) : (InvoiceAmount*percentage*0.01)
Percentage (integer): (Example-50)

SCENARIO:
The invoice amount needs to be charged to the different departments. The accounting clerk enters the percentage, and the line charge is automatically calculated.

But, if the invoice amount is 5.29 and needs to be divided to two departments by 50%, it calculates $2.65 for each which totals up to $5:30.

ANY SOLUTION for this wrong calculation?