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

Ninox Profile

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