Auto-sum fields in SP list

(0) Share

Report

Posted on by Virikefe22

302

Hello, I wish to calculate the last set of 8g showing Night in the column Duty

Right now, it's displaying the last value on the gallery but I want it to calculate all the set of data in the MONRING shift. MORNING shift comes in hourly basis... 7am, 8am, 9am and so forth... so while the data is dropping in the hourly order, I want it added to the data once it is posted or I want it updated on this Pallets label.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Virikefe22,

My first try would look something like this:

Sum( Filter( 'Savoury Hourly Performance Tracker', DateValue(Created) = Today(), Duty.Value = Last( Sort( 'Savoury Hourly Performance Tracker', Created, Descending ) ).Duty.Value ), 8g )

This filters the data source by the Created column to match today's date and to match the last type of shift. The values in the 8g column of the remaining row are then summed to created the requested number.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Virikefe22 ,
You can try using below formula -
With({_date: First(Sort('Savoury Hourly Performance Tracker', Created, Descending)).DATE}, Sum(Filter('Savoury Hourly Performance Tracker', DUTY.Value="Morning" && DATE=_date),'8g')

Was this reply helpful? Yes No