Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Summing rows

Topic Labels: Automations Formulas
Solved
Jump to Solution
1709 3
cancel
Showing results for 
Search instead for 
Did you mean: 
KlaDa
5 - Automation Enthusiast
5 - Automation Enthusiast

Dear community

I need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...

I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.

Basically: #Beløb F + #Beløb S = Beløb

Skærmbillede 2023-06-08 kl. 11.41.13.png

Can anybody help?
Skærmbillede 2023-06-08 kl. 11.41.13.png

Uffe, Klassiske Dage, Holstebro International Music Festival

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

Hi,

Edit Beløb field settings, choose Formula instead of Number, put your formula ( #Beløb F + #Beløb S ) in formula editor window. If field name contain space or some non-letter chars, it needs to be wrapped like this:
{Beløb F} + {Beløb S} . Just start and then click on hints, you will see it's very easy.

See Solution in Thread

3 Replies 3
Alexey_Gusev
13 - Mars
13 - Mars

Hi,

Edit Beløb field settings, choose Formula instead of Number, put your formula ( #Beløb F + #Beløb S ) in formula editor window. If field name contain space or some non-letter chars, it needs to be wrapped like this:
{Beløb F} + {Beløb S} . Just start and then click on hints, you will see it's very easy.

KlaDa
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks a lot. 

melissaprinz
4 - Data Explorer
4 - Data Explorer

 

Explore Unity Church, a community of faith rooted in love and inclusiveness. Together, we embrace the journey toward spiritual growth and peace. Join Unity Church to celebrate faith and unity. Be part of a compassionate community committed to living out the teachings of love and harmony.