I am trying to get the percent (Rate) by month (shown as 1 and 2). It's the Count of that month divided by the total for that PoolPlusID (show highlighted green). Ex. 235 / 116,093 for .20%... I'm using Count \ SUM(total COUNT_ACCT_ID) and it works for that one row selected, but once I select another record (show in 2nd screenshot) it changes the the Rate from .20% to .19% because it adds 6,704 to the total. I want it always to divide by the total for it's individual PoolPlusID... Any ideas?
Doesn't seem to be working, it drastically changed the Rate/percentage.
I edited my original Question to hopefully better explain. The calculation works on a per PoolPlusID selection, but once I select another, the 235 is divided by both totals (122,797 = 116,093+6,704), not just the 116,093
Would some sort of Aggr function work to do it by PoolPlusID?
I had SOME success getting the 116,093 total using the below:
(my count of 225) / Sum(Aggr( Count(COUNT_ACCT_ID), POOLPLUSID))
But then this only gives me a Rate(percentage) for the first month, my other months are blank.
Per Marcus' comment, the following links should be helpful:
If you want further direct assistance, I would recommend attaching the QVW file to the thread, as that will be the most useful thing, as people can then see the full data model and your expressions etc. as they are being used in the object.