0
Problem with this formula
sum((select Expenses).'Amount Spent' where Categories = "Gas")
sum((select Expenses).'Amount Spent' where text(Categories) = 8)
Where Categories is a Choice field.
6 replies

You need the "where" within the select statement
sum((select Expenses where text(Categories) = 8).'Amount Spent')
or alternatively
sum(select Expenses[text(Categories)= 8].'Amount Spent')
Both should work the same
Content aside
 Status Answered
 1 yr agoLast active
 6Replies
 46Views

3
Following