Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to show a cumulative total based on multiplied values from two fields in a bar graph.
I need to use set analysis to multiply each month's census * credits to come up with the cumulative target for each month.
Unfortunately if I tell it to give me the months less than this month (Jan-July), sum (Census) * sum(Credits) it multiplies 1050 * 28 (29400) where as I need it to multiply and add each row independently to give me 4200.
| Month | Census | Credits | Total | Cumulative Target |
| January | 145 | 4 | 580 | |
| February | 145 | 4 | 580 | 1160 |
| March | 152 | 4 | 608 | 1768 |
| April | 152 | 4 | 608 | 2376 |
| May | 152 | 4 | 608 | 2984 |
| June | 152 | 4 | 608 | 3592 |
| July | 152 | 4 | 608 | 4200 |
| August | 152 | 4 | 608 | 4808 |
| September | 152 | 2 | 304 | 5112 |
| October | 152 | 4 | 608 | 5720 |
| November | 152 | 4 | 608 | 6328 |
| December | 152 | 4 | 608 | 6936 |
Try this.
RangeSum(Above(TOTAL Sum([Census ]*Credits), 0, RowNo(TOTAL)))