Sep 05 2024 09:17 AM - edited Sep 05 2024 10:01 AM
Hello, I've created two field calculations. The first is Regular hours, based on whether 40 or not (post edited to correct initial statement). The line calculations are correct, but the totals are not summing for the Regular hours. Value field "summarize" setting is Sum. The second issue is Overtime, also conditional upon the item type; it is ignoring the first part of my If statement, but calculating the second part for all. These are pretty simple formulas, and I've used them before. Any ideas on what I need to do?
Sep 05 2024 10:53 AM - edited Sep 05 2024 01:16 PM
Hi @ssternke
You reached "classic" PivotTable limitations. Doable with Power Pivot if you run Excel >/= 2013 on Windows
Sep 05 2024 11:04 AM
@Lorenzo Interesting! Thanks so much, I will give this a try.