Questions: STUCK - Set Analysis - Current and Prior Period where the total is > 0
I have tried organizing this in many ways but I have been stuck on this for a week. I am trying to sum the net total of Funds for the group where the total of funds for the master group is > 0 for the current period and the prior period. So far I can't get the first one to give me the right amount it keeps giving me the total of the master group not the group. I just want to use the total of the master group to select the groups I want to include in my total. Second when I do the same calculation for the perious period it includes the last selected month of the current year. I really want the period to be this year up to month selected and last year up to same month selected.
I use a Master Calendar and select year = 2014 and month = 4.
I was able to use your examples to verify that the expression I have is constructed correctly. I was trying to apply some of your examples to then pick the prior period (same month prior year) but it doesn’t return the correct amounts it returns current year amounts. See below: