Skip to main content
Solved

Run A Formula - Sum


Forum|alt.badge.img+4
  • New Member
  • 66 replies

Hi Guys, how do I do additions of multiple currency fields, tried formula below & its not working

 

Best answer by thassia

Hello @TMZ 

 

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. 

 

View original
Did this topic help you find an answer to your question?

27 replies

marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • May 31, 2024

Hi, @TMZ 

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

 

 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 3, 2024

Hi @marcosmelo,  thank you for your feedback, & i hope you had a great weekend.  I've added using +symbol.  The Total Field is currency & nothing is happening .

 


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • June 3, 2024

Hi, @TMZ , tks

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


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 3, 2024

Hi @marcosmelo, thanks again for your feedback.  I’ve adjusted the automation to ‘A card enters a phase’, however unlike when I tried earlier it’s not giving me the option of selecting dynamic fields that I have added. Added Dynamic Field called ‘Total Test’, the field Test is ‘Short text’. When i go to add the fields into the Dynamic Field ‘Total Test’, I cant find it in the drop down

 


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • June 3, 2024

Hi, @TMZ 

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.
 

 

 

 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 4, 2024

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

 

 

 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 4, 2024

Hi @marcosmelo I have also tried to add more ‘Dynamic Fields ’and they are not an option in the dropdown for the automation process. These are all the Dynamic Fields

I can't find any of these Dynamic Fields when creating the automations

 


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • June 4, 2024

Hi, @TMZ 

 

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.


rachel-antonini
Pipefy Staff
Forum|alt.badge.img

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


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 4, 2024

Hi @marcosmelo No problem, will try contact them & get back to you. thanks


Amanda Dianni
Pipefy Staff
  • Software Engineer
  • 17 replies
  • June 4, 2024

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.


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 4, 2024

Hi @amanda-dianni, I think that could be the reason (if I’m also able to add total to a ‘Short Text’ field.  To keep the form as short and clean as possible i have added conditions so if there is a multiple flights it will display them accordingly (e.g. 5 flights  shows 5 fields with flight price - therefore it should give the sum of 5 flights, 1 flight  shows 1 field & therefore it should give the Sum of one flight) so now with what you have stated how will I be able to make it work without having unnecessary fields in the form (1 flight showing 5 fields, with only one field having a price and the others not having a price).

Also why is it not displaying the dynamic fields I have added in the automation? 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 4, 2024

Hi @amanda-dianni it worked, filled in all the fields & the Sum was in the Text & Dynamic fields.

So just 2 questions:

  1. How do I add conditions & keep it clean & easy like I mentioned above. Please check the conditions below.  Will the Sum function work with the Conditions?
  2. Why are my new Dynamic fields not showing in the Automation

thanks guys

 


Amanda Dianni
Pipefy Staff
  • Software Engineer
  • 17 replies
  • June 4, 2024

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.


Amanda Dianni
Pipefy Staff
  • Software Engineer
  • 17 replies
  • June 4, 2024

For the formula, you could set one (or maybe multiple) automation to fill the empty fields with 0 if they are empty.

 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 5, 2024

Thanks @amanda-dianni will give it a shot & give you feedback


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 10, 2024

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.


Amanda Dianni
Pipefy Staff
  • Software Engineer
  • 17 replies
  • June 11, 2024

@TMZ I’m sorry, I’ve just noticed our conditions for numeric fields don’t have the option of empty value :/ 


thassia
Forum|alt.badge.img+3
  • Brainy
  • 55 replies
  • June 12, 2024
TMZ wrote:

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 @TMZ ,

 

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.


thassia
Forum|alt.badge.img+3
  • Brainy
  • 55 replies
  • June 12, 2024
TMZ wrote:

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.


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 12, 2024

Hi @thassia, thank you for your response.  Please can you give me an example with a screenshot?


thassia
Forum|alt.badge.img+3
  • Brainy
  • 55 replies
  • Answer
  • June 12, 2024

Hello @TMZ 

 

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. 

 


Lais Laudari

Great tip @thassia 😃


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 12, 2024

Hi @thassia, thank you, will give it a try shortly and give you feedback


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • June 12, 2024

Thanks @thassia it worked! Much appreciated!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings