Announcements
Hi Sorry to bring this problem back again I have been trying to get it to work for hours.
Are you getting an error ? it is working for me
----------------------------------------------------------If I have answered your question, please mark your post as Solved. 🆗✔️If you like my response, please give it a Thumbs Up. 👍
The Function Sum has some invalid arguments.
Name isnt valid Category isnt recognised.
Incompatible types for comparison these types cant be compared. Error, Text
Name isnt valid Credit isnt recognised.
And a delegation warning.
what are the types of Category and Credit fields ?
It was an excel I imported into dataverse. Data types look like floats
Could you please be precise and share the screenshot of the table definition from dataverse so I can try it and reproduce the error
Its OK I got it working on a Sharepoint list will go with that. Will keep trying dataverse.
The sum formula works fine in sharepoint lists but doesnt in dataverse. Credit field is number and Category field is a selection text.
ok I better understand. This should work for you
Sum(Filter(Ledger2324S,Category=[@'Category'].Fundraising ),Credit)
Hi sorry
I have attached 2 screenshots. One of dataverse table and one of the powerapp page i am trying to get. Sorry for the hastle.
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 394 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 324 Most Valuable Professional
