topic Get Rangesum to work in Line Chart in App Development

Get Rangesum to work in Line Chart

adontchosgarnet — Sat, 16 Nov 2024 16:35:26 GMT

I have an expression in a pivot table that works perfectly. However, it does not work in a line graph. Anyone know how to fix this?

The expression is:

Rangesum(Before(Sum({<[Payment_vs_ChargeOff]={">=0"}>}Transaction_Amount),0,ColumnNo(TOTAL)))

My x-axis (Payment_vs_ChargeOff) is a number months past a certain point and my dimenson is the ChargeOff Year. So, each line represents a year and each point on the line is the number of months past the charge off date.

My y-axis is the cumulative total of the transaction amount.

Re: Get Rangesum to work in Line Chart

Kushal_Chawda — Wed, 25 Sep 2024 19:32:55 GMT

@adontchosgarnet Before() and ColumnNo() functions are specific to pivot table, it will not work in any other charts except pivot table. You can use, above() or below() with rowno(). Probably like below. You can change it to below accordingly

Rangesum(above(Sum({<[Payment_vs_ChargeOff]={">=0"}>}Transaction_Amount),0,RowNo(TOTAL)))

Re: Get Rangesum to work in Line Chart

adontchosgarnet — Wed, 25 Sep 2024 21:22:43 GMT

You sir, are a steely-eyed missile man! Thank you!