How to calculate a sum of a part of data lines
Ninox Profile

Hallo, I like to make a sum of all data, which have the same value in a second colume. For example:

Colume one: "Leistung" Values (Beratung / Nebenkosten )

Colume two: "Berechnung" Value = €

I like to install a field which calculate the sum of "Berechnung" if the correspondent field "Leistung" is the value "Beratung".

Thanks for your help.

regards Martin

N

Hi Martin,

if the Leistung is choice field and Beratung is the first choice, use formula field with this code:

 

sum((select YourTable where Leistung = 1).Berechnung)

 

Nick

Ninox Profile

Hi Nick,

 

thanks for your help. I did the same wihtout any positiv result. I think the data structure is the problem. So I will check this point now.

Thanks

Martin

T

Hallo Martin,


Deine Felder sehen Deutsch aus. Es gibt auch ein deutsches Forum:


https://ninoxdb.de/de/forum/technische-hilfe-5ab8fe445fe2b42b7dd39ee8

Reply