Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
For the chart below, I need to get the percentage that each row makes up of the total for given TX_POST_DATE. For instance, for 3/20/2019, we'd expect to see Commercial be 6,540,756.95 of 23,673,227.17 (or 27.6%). I tried using AGGR:
=sum(aggr(Sum({<AmountType = {'HB Chg'}>}TrxAmount), TX_POST_DATE))
...but it puts it on a row separate from the payor rows. The third column is:
=Sum({<AmountType = {'HB Chg'}>}TrxAmount)
Any ideas? This seems like a fairly simple thing to do, but I haven't been able to find the solution yet.
Thanks in advance,
Chris
Try this
Sum({<AmountType = {'HB Chg'}>} TrxAmount)/
Sum(TOTAL <TX_POST_DATE> {<AmountType = {'HB Chg'}>} TrxAmount)
or
Sum({<AmountType = {'HB Chg'}>} TrxAmount)/
Aggr(NODISTINCT Sum({<AmountType = {'HB Chg'}>} TrxAmount), TX_POST_DATE)
Try this
Sum({<AmountType = {'HB Chg'}>} TrxAmount)/
Sum(TOTAL <TX_POST_DATE> {<AmountType = {'HB Chg'}>} TrxAmount)
or
Sum({<AmountType = {'HB Chg'}>} TrxAmount)/
Aggr(NODISTINCT Sum({<AmountType = {'HB Chg'}>} TrxAmount), TX_POST_DATE)