Copy link to clipboard
Copied
From a normal field that has sum total I need calculate one of three percentages off 50, 75 or 90...from whatever number is in that total filed. I know how to do the math..x number *.5 or .75 or .90 gives the number but I am having trouble creating that with the form fields please help as I am up against a deadline...
Copy link to clipboard
Copied
If the total field is called Total and the total after discount is called DiscountedTotal, use the following formula in the Simple Field Notation option of the Calculate tab of the DiscountedTotal field:
Total * 0.5
or
Total * 0.75
or
Total * 0.9
Copy link to clipboard
Copied
thank you ... will try now...
Copy link to clipboard
Copied
so after being multiplied then needs to be subtracted from previous total as well so if Total is $100 and percent of funding is 75% then the calculation needs to in the Grand Total Due field needs to take $25 off and show $75.
Copy link to clipboard
Copied
So use this formula for the Grand Total
Total - DiscountedTotal
Copy link to clipboard
Copied
Try67, back where the user needs to select one of three options (50%, 75% and 90%) that's where I am having a mental block ...I know the Total - DiscountedTotal,,,that's why I included the snapshot of form...I do apologize for not getting this one...normally not an issue...
Copy link to clipboard
Copied
Ah, so the discount is based off of a selection... That was not clear to me until now.
Well, instead of using a free text field you should use a drop-down, and then you will be able to use the drop-down field's value directly in your calculation.
Copy link to clipboard
Copied
ok..here is the edit visual
Copy link to clipboard
Copied
Still looks like a text field to me...
Copy link to clipboard
Copied
Copy link to clipboard
Copied
It seems OK, but please don't post just screenshots without any explanations. Is it working now, or not?
Copy link to clipboard
Copied
try67...thank you for saying please but i am in a very busy work environment at present as the only IT & Web Admin and can't always have text...though made sense in context...yes working but look at next post as i increase numbers at top until value is selected
...
Copy link to clipboard
Copied
then once selected it correctly populates
Copy link to clipboard
Copied
I'm sorry, I don't follow what's going on there. Would it be possible for you to share the actual file?
You can upload it go Dropbox, Google, Adobe Document Cloud, etc., and post the link to it here.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Hope this helps: If you are trying to show 75% Off on a total cost, this means the total should be 25% of the cost, so when you multiply the total by .25, you will get the total to show only 25% of it. Which in turn means the Total is less 75%. E.g - Less 80% - multiply cost by 0.20; Less 12% - multiply cost by 0.88 etc...
Copy link to clipboard
Copied
included visual..
Copy link to clipboard
Copied
What is this supposed to tell me?