Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
