Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Percentage off total calculation in Adobe Pro Forms

New Here ,
Feb 07, 2017 Feb 07, 2017

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...

TOPICS
PDF forms
3.7K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

thank you ... will try now...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

So use this formula for the Grand Total

Total - DiscountedTotal

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

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...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

ok..here is the edit visual

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

Still looks like a text field to me...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

It seems OK, but please don't post just screenshots without any explanations. Is it working now, or not?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

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

...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

then once selected it correctly populates

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 08, 2017 Feb 08, 2017

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 02, 2023 Jun 02, 2023
LATEST

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...

 

MelSwan_0-1685700910577.png

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 07, 2017 Feb 07, 2017

included visual..

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 07, 2017 Feb 07, 2017

What is this supposed to tell me?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines