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 actual SMA expenses table)
-Contains Actual Allocations to Total Division
-Combo
-Include McDonalds
Table 2 (0014 AFE PA Data w/ Data Combos Table)
-MBU
-Include McD
Where Combo = MBU and Include McDonald’s = Include McD, I want to return the sum of the Actual Alloc to Total Division. The formula I came up with is returning the complete total for Actual Alloc to Total Division regardless of the 2 criteria.
My formula:
MBU test: DSum("[Actual Alloc to Total Division]","0014a update actual SMA expenses table","COMBO='" & [0014 AFE PA DATA w/ Data Combos table]![MBU] & "'" And "Include McDonalds='" & [0014 AFE PA DATA w/ Data Combos table]![Include Mcd] & "'")
Thanks in advance!!
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 actual SMA expenses table)
-Contains Actual Allocations to Total Division
-Combo
-Include McDonalds
Table 2 (0014 AFE PA Data w/ Data Combos Table)
-MBU
-Include McD
Where Combo = MBU and Include McDonald’s = Include McD, I want to return the sum of the Actual Alloc to Total Division. The formula I came up with is returning the complete total for Actual Alloc to Total Division regardless of the 2 criteria.
My formula:
MBU test: DSum("[Actual Alloc to Total Division]","0014a update actual SMA expenses table","COMBO='" & [0014 AFE PA DATA w/ Data Combos table]![MBU] & "'" And "Include McDonalds='" & [0014 AFE PA DATA w/ Data Combos table]![Include Mcd] & "'")
Thanks in advance!!