Thank you! That worked. The issue is that I have 9 other Combos (besides MBU) that I'm going to have to create different queries for and then append all together since I can't get the Dsum syntax right :banghead:
Hi – I’m really struggling to get this DSum formula to work and I’m hoping someone can help. I would be so grateful!
What I’m attempting to do is sum the Actual Alloc to Total Division based on the combination of fields COMBO and MBU and whether Mcdonald’s is included.
Table 1 (0014a update...