0

sum up the amount of expenses

There is a table projects and it contains a sub-table with the expenses name
There is also a dynamic selection field that displays the name of the expense.
When selecting an expense name in the dynamic selection field, i need to calculate the entire expense amount for this section

let c := this.Expenses;
let x := (select 'Expanses name' where Expenses = c);
sum(for r in x do
        r.Amount
    end)

This phone does everything correctly, but it calculates the sum from the entire table, and not from the open project.
Who can help correct the formula?

1 reply

null
    • Fred
    • 3 days ago
    • Reported - view

    If you only want to look at the subtable then you don't need the select or the for loop:

    let c := Expenses;
let x := sum('Expenses name'[Expenses = c].Amount);
Login to reply

Content aside

  • 3 days agoLast active
  • 1Replies
  • 17Views
  • 2 Following