PDF ROUNDUP CALCULATION
Please help a novice = ME!
I am multiplying 2 fields 'Entry1' and 'Entry2' and 'TOTALEntry1' should display the result. I formatted the NUMBER to 0 decimal so I could get the ROUND-UP number. 'Entry3' should be multiplied to 'TOTALEntry1' but picking up the true value of 'TOTALEntry1' which is 1 instead of 0.72.
This is what I want:
Entry1 (12) x Entry2 (6%) = TOTALEntry1 (1) x Entry3 ($6,005) = TOTALEntry2 ($6,005)
This is what I am getting:
Entry1 (12) x Entry2 (6%) = TOTALEntry1 (0.72) x Entry3 ($6,005) = TOTALEntry2 ($4,323.60)
Please help.
