There is a lot of post about this but a can't seem to make this work.
Here is my data table.
I want to have a test book that displays the total of the Fee Amount colour. I have tried sum(Sales_Pipeline, "Fee Amount") but nothing is returned.
What am I doing wrong?
Hi @LaingBennett ,
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Assuming that fee amount is the name of your column (which contains a space), you should try using single quotes instead of double quotes.
Sum(Sales_Pipeline, 'Fee Amount')
If the value that this returns isn't correct, it will most likely be related to delegation issues if you're using a SharePoint list as your data source.
Hi @LaingBennett ,
For the Data table, you can use the Same code for Sum All records.
"Total Sum "&Sum(GroupByTest,'LINE No')
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
This should work, so I'm not quite sure why it's not showing any data for you.
To confirm whether or not this is a delegation issue, how many rows do you have in your spreadsheet?I notice in your original screenshot, there is a red error icon against your label. Can you tell us the error message that appears against this label?
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021