Hi Guys, how do I do additions of multiple currency fields, tried formula below & its not working
![](https://uploads-us-west-2.insided.com/pipefy-en/attachment/db7cb3a8-c2d3-468d-a194-9d5e3f41456c.png)
Hi Guys, how do I do additions of multiple currency fields, tried formula below & its not working
Hi,
I did a test here on my panel and it worked.
In the formula, try adding the fields by the + symbol to look for dynamic currency fields.
In your account total, the destination field must be currency
Hi
Hi,
do a test using another trigger, for example, when a card enters a specific phase and do a test by moving the card to see if it works. If it works, check if the previous trigger you were using was configured correctly, remove the browser caches and if it still doesn't work, I suggest you contact the support team. great week to you!!
Hi
Hi,
Try refreshing the page after creating new fields. If the field was created in the phase settings, make sure it appears in the phase section when creating the automation.
Here I created the short text field and did the tests according to your scenario and it worked.
Hi @marcosmelo thanks again for the feedback. However still not getting the desired results. For some reason the system won't give me the option to make the ‘Dynamic Field’ equal total, in your illustration ‘Test Total’ is a dynamic field. It only gives me the option of the ‘Short text’ field. I’ve restarted my laptop & refreshed it. Please can I make you a Pipe administrator so you can take a look. thanks
Hi
I can't find any of these Dynamic Fields when creating the automations
Hi,
In this case, since the fields do not appear for you to select them, I suggest you contact the support team and they can check your Pipe.
Hello!
If you use the + symbol, then you shouldn't use the word “SUM” Test without the word, just the fields and the + sign.
Let me know if you're still having problems. ;)
Hi
It’s important to remember that if one of the fields included in the formula is empty, the formula will fail. You can see if there was an error in the automation using the automation logs button.
Hi
Also why is it not displaying the dynamic fields I have added in the automation?
Hi
So just 2 questions:
thanks guys
About the dynamic fields, they are not available to be update by automations. You have to update another type of field, and using this field inside your dynamic field content.
For the formula, you could set one (or maybe multiple) automation to fill the empty fields with 0 if they are empty.
Thanks @amanda-dianni will give it a shot & give you feedback
Hi @amanda-dianni , i hope you are well & had great weekend. Please can you assist on how I can add conditions to the sum calculation because I tried playing with it over the weekend but to no avail.
Hi @marcosmelo thanks again for the feedback. However still not getting the desired results. For some reason the system won't give me the option to make the ‘Dynamic Field’ equal total, in your illustration ‘Test Total’ is a dynamic field. It only gives me the option of the ‘Short text’ field. I’ve restarted my laptop & refreshed it. Please can I make you a Pipe administrator so you can take a look. thanks
Hello
Did you try to add a numeric field instead of a dynamic content field? Maybe it will show in your automation if you use a numeric field.
Hi @amanda-dianni , i hope you are well & had great weekend. Please can you assist on how I can add conditions to the sum calculation because I tried playing with it over the weekend but to no avail.
Maybe you can try to add an automation to update your trip field to “0” when a new card is created.
Hi @thassia, thank you for your response. Please can you give me an example with a screenshot?
Hello
Sure! You can see below.
Automation to update the trip field when a card is created
And the automation to use SUM
The fields trip 1, trip 2 and Total Trip must to be as numeric fields.
Hi
Thanks
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.