I have been trying different formulas without success if I want to Filter by a date range. The Sum function with my currency field without date as a criteria works fine even though I get the delegation warning.
I looked around the forum and tried a few things but no sucess.
My Goal: Sum up the 'Amount' column from my List called 'MaintenanceExpenses' for a specified date range based on 'ExpenseDatePickerFrom' and 'ExpenseDatePickerTo'. The date picker compare the date with my 'Created' column.
I have a SharePoint List with a column 'Amount' that is of Currency type.
My App and formula:
Text(Sum(Filter(MaintenanceExpenses,Value(Text(Created,"[$-en-US]mm/dd/yyyy")) >= ExpenseDatePickerFrom.SelectedDate,Value(Text(Created,"[$-en-US]mm/dd/yyyy")) <= ExpenseDatePickerTo.SelectedDate),Amount),"[$-en-US]$#,###0.00")
Most likely I'm making a very basic mistake. Any suggestion would be amazing!
Solved! Go to Solution.
yes you got it. glad to see you sorted the filter. good luck with the app, have fun.
I am adding a bit of detail to conclude my challenge and hopefully help someone in the future.
The 'Created' field date format setting was set to 'Friendly'. I changed it to 'Standard' and was able to get the math accurate in my Sum. It was preventing my '>=' to work.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!