Skip to main content

If one of my solutions has a negative number, how do I write the formula?

I can add each number field and get a correct outcome, but I don't know if I can create the formula to capture a negative number and positive numbers in the same formula.

Current formula = [R1 ExOTC] + [R2 ExOTC] + [R3 ExOTC] + [R4 ExOTC] + [R5 ExOTC]

image

Hi,

Thank you for reaching out here in the DocuSign Community.  

I understand that you would like to confirm if the Formula Standard Field supports negative numbers and I will gladly share more details on the topic.

By default, Forumula fields will support negative numbers, in this scenario specifically the same sum formula should work without any issues using both positive and negative numbers.

For detailed steps on how to set up a formula field, see:

Mathematical operations in formulas

Feel free to let us know if you need further assistance with this. 

Thank you for using DocuSign, we hope you have a wonderful rest of your day! 

Best regards, 

Alejandro R. | DocuSign Community Moderator 

"Select as Bestbelow if you find the answer a valid solution to your issue! 


Thanks for the information.


Hi,

Thank you for following up. 

  

I am glad to hear that you found the resources I shared useful, please take into consideration selecting the comment as the "Best Answer" if you find that it helped you solve your issue. 

  

And, please don't hesitate in letting me know if you have any other questions or concerns and I will address them as soon as possible.  

  

Best regards,  

Alejandro R. | DocuSign Community Moderator  

  

"Select as Bestbelow if you find the answer a valid solution to your issue!  


Reply