Help

Summing rows

Topic Labels: Automations Formulas
Solved
Jump to Solution
691 2
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
12 - Earth
12 - Earth

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

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

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.