Copy link to clipboard
Copied
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? 🙂
Copy link to clipboard
Copied
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:
Product | Product_Description | PRICE PER CASE | EA PER CASE | Price per 1000 EA |
Item#1 | Item#1 Description | {{$cpf1} | {{$csf1}} | {{$pptf1}} |
Item#2 | Item#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.
Copy link to clipboard
Copied
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.