Announcements
Hi,
I am trying to do sum for rating column but only for is active=true ids so can some one tell me how to do it
I used sum( table name , rating) but it will show all rating sum , need only active ids sum
Hi @Sweety
Syntax:
Sum(Filter(Datasource, Condition), ColumnName)
To avoid delegation warning
With( {sData: 'Issue tracker'}, Sum( Filter( sData, IsAccepted = true ), 'Days old' ) )
Sample:
@Sweety
You'll need to filter your table by the condition for active or not active.
Ex.
With({_items: Filter(tableName, active=1)}, Sum(_items, rating) )
Note, in the above "active=1" is provided as an example only. Please substitute in the condition that you have for determining an active record.
I hope this is helpful for you.
Were you able to work through your issue or do you still need help?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 258
Mohsin Ali 231
