0

How to calculate a sum of a part of data lines

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

3 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    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

    • MGrosse
    • 6 yrs ago
    • Reported - view

    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

    • Tacho
    • 6 yrs ago
    • Reported - view

    Hallo Martin,

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

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

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2615Views