I have created 7 different decimal number fields, one for logging work hours of each day of the week. I created an 8th decimal field, "Total Hours", that uses a calculation to add up each of the days of the week's hours. However, if one of the 7 fields that the "Total Hours" field is calculating is blank, then the Total Hours shows up as blank.
I believe this is a bug.
in my case trying to sum the value of fields that contains numbers.
and works but if one of the fields does not have a number, otherwise his value is -blank- automatically the value of the sum autocalculated field is -blank-
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021