I'm tyring to write a formula to calulate a percentage. I have had some sucess but it is not correct. I 1st haved added the following in a formula called poundage (see below). I then took and created a new formula called "1.5" - In this forumla is "1.5 * @Poundage" This results in the correct number but it does not have the decimal point.
Example - 3529 should be 35.29
Poundage formula is as follow:
+({@Clerk Fees to Num})
+ 3.50
+ ({cpmain.servicefee})
+ ({@Ad Fees to Num})
+ 51.00
Objective - My total amount will always be 1.5% of the total of the amounts that are added up above.
I know there should be an easier way to do this, I just have not figured it out. Any help would be greatly appreciated. Thanks in advance.
Example - 3529 should be 35.29
Poundage formula is as follow:
+({@Clerk Fees to Num})
+ 3.50
+ ({cpmain.servicefee})
+ ({@Ad Fees to Num})
+ 51.00
Objective - My total amount will always be 1.5% of the total of the amounts that are added up above.
I know there should be an easier way to do this, I just have not figured it out. Any help would be greatly appreciated. Thanks in advance.