Summing Up

(0) Share

Report

Posted on by AF-19080433-0

147

Hi Sorry to bring this problem back again I have been trying to get it to work for hours.

Sum(Filter(Ledger2324S, Category = "Fundraising"),Credit)

Ledger2324S is a dataverse table.

Trying to sum all the Credit Categories if it is a Fundraising cat and a credit

Like sunif.

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

abouchaalaBAIT 932 Moderator on at

Like (0)

Report

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. 👍

Was this reply helpful? Yes No
AF-19080433-0 147 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

what are the types of Category and Credit fields ?

Was this reply helpful? Yes No
AF-19080433-0 147 on at

Like (0)

Report

It was an excel I imported into dataverse. Data types look like floats

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

Could you please be precise and share the screenshot of the table definition from dataverse so I can try it and reproduce the error

Was this reply helpful? Yes No
AF-19080433-0 147 on at

Like (0)

Report

Its OK I got it working on a Sharepoint list will go with that. Will keep trying dataverse.

Was this reply helpful? Yes No
AF-19080433-0 147 on at

Like (0)

Report

The sum formula works fine in sharepoint lists but doesnt in dataverse. Credit field is number and Category field is a selection text.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
ok I better understand. This should work for you
Sum(Filter(Ledger2324S,Category=[@'Category'].Fundraising ),Credit)

Was this reply helpful? Yes No
AF-19080433-0 147 on at

Like (0)

Report

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.

powerapp.jpg

dataverse.png

Was this reply helpful? Yes No