Skip to main content
C
Carissa5C59
Participant
August 25, 2023
Question

Fillable PDF Formula/Function

  • August 25, 2023
  • 1 reply
  • 372 views
Fillable PDF Formula/Function

Hopefully, someone out there can help me out with this. I have been racking my brain and googling away and can't seem to find this formula/function ANYWHERE!

 

I know what the function/formula is in Excel, but I can't figure out how to do it in the fillable PDF.

 

Excel Function: MRound (ADDCELLHERE/2,12)

 

so I'm looking to MRound the number in the specific cell, divide it by 2 but convert it to the closest multiple of 12. If that makes any sense? 🙂

This topic has been closed for replies.

1 reply

L
Lisa294547841hqx
Participant
August 25, 2023

I need to upload a document with text tags to get pricing from a supplier.  The returned document will be part of a Power Automate flow to get internal approval for the prices the supplier provided and then update our internal files with the new prices.  During the signing process the supplier will enter the price per case which is a required field.  Then calculated fields will enter the qty per case and the cost per 1000.  I can't seem to make this work.   On one of the support docs I read that advanced form fields and functionality must be enabled on my account.  Included in my Adobe plan is Enterprise PDF Services Developer, PDF Services, Acrobat PDF Pack.  Is the problem due to not having the fuctionality enabled in my adobe account or am I missing something in the syntax of the text tags?

 

Here's what my document looks like:

ProductProduct_DescriptionPRICE PER CASEEA PER CASEPrice per 1000 EA
Item#1Item#1 Description{{$cpf1}{{$csf1}}{{$pptf1}}
Item#2Item#1 Description{{$cpf2}{{$csf2}}{{$pptf2}}

 

Then on another page of the file I have:

{{#REMOVE_PAGE_FROM_OUTPUT}}  
   
{{#cpf1=*cpf1_es_:signer1:format(Number,"$,0.00"):align(right)}}{{#csf1=csf1_es_:signer1:calc(1500):align(center)}}{{#pptf1=pptf1_es_:calc([cpf1]/[csf1]*1000):format(Number,"$,0.00":align(right)}}
{{#cpf2=*cpf2_es_:signer1:format(Number,"$,0.00"):align(right)}}{{#csf2=csf2_es_:signer1:calc(900):align(center)}}{{#pptf2=pptf2_es_:calc([cpf2]/[csf2]*1000):format(Number,"$,0.00":align(right)}}

 

Here a snip of the signed document where the supplier entered $500 for the Price per case on each of 3 lines. 

 

L
Lisa294547841hqx
Participant
August 30, 2023

I upgraded by account to AdobePro which resolved the problem.  These tags must be what Adobe considers to be "advanced form fields" and not included in the package I was subscribed to.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices