0

How to sum only some records from a subTable based on another field in the records

In the Main-record

I have a SubTable

and each SubTableRecord has got a number field

each SubTableRecord also have a choice-field that can be set to "Yes" or "No"

 

In my Main-record

I would like to Sum the values from the SubTableRecords

BUT only those SubTableRecords where the choice-field is set to "Yes"

 

Does that make sence ?

 

SumIfYes

(Cant get image to look correctly)

/John.

3 replies

null
    • KAXIG ApS
    • John.1
    • 3 yrs ago
    • Reported - view

    okay it looked okay when posted.

    • hello.1
    • 2 yrs ago
    • Reported - view

    Try this in the formula field:

     

    (sum('YourTableName'['YourChosen' = 1].'YourTotalEstimate')

    • KAXIG ApS
    • John.1
    • 2 yrs ago
    • Reported - view

    Thanks :)

Login to reply

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 647Views