Add Calculated Totals to a Sub-Query Field with an Advanced Function applied
My biggest issue is I am having a hard time understanding why the "Calculated Total" does not work on the Advanced Function.
I will try to explain what I mean. Also to note... I found the way around it (which didn't work in other versions), but it seems unnecessary.
1) Subqueries for Prior YTD and Current YTD:
2) Calculated Field for Difference in 2 subquery calcs (on main query):
3) CF on table and attempt at Advanced Function (from main query):
4) Tried to use Sub-Query Field from Current YTD:
I hope this makes sense. I may be making a big deal out of nothing, but I wasn't sure if this "work-around" was intended...