topic Re: How to use RangeRum and Above in App Development

How to use RangeRum and Above

dotnetfan — Thu, 12 Sep 2019 10:33:58 GMT

Hello Guys,

Now I'm working on a report, the requirement is to display aggr values for each month and week as following

	July	July	July	July	August	August	August	August
Week Number	27	28	29	30	31	32	33	34
Actual Value	1	2	3	4	5	6	7	8
Aggr value	1	3	5	9	5	11	18	26

Now I used following expression to display values but I don't know how to show it based on week and month:

RangeSum(Above(Sum("Actual Value",0,RowNo()))

Thanks!

Dotnetfan

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 10:40:37 GMT

Is Week Number a dimension here too? How else are you making Month Repeat in the dimension?

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 11:18:19 GMT

May be you need this (if this is in a pivot table)

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

Re: How to use RangeRum and Above

Frank_Hartmann — Thu, 12 Sep 2019 11:16:29 GMT

missing ')'

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 11:17:42 GMT

Yup, thanks for pointing that out

Re: How to use RangeRum and Above

dotnetfan — Thu, 12 Sep 2019 11:42:43 GMT

Hello,

Here is the source data

Column #1 is the month, #2 is week number, #3 is the expression and it looks doesn't work. Column #4 is the sum value and the last column is the expected output.

Month	Week	RangeSum(Above(Sum(Value), 0, RowNo()))	SUM(Value)	Expected
7	27	325	325	325
7	28	327	327	652
7	29	385	385	1037
7	30	413	413	1450
8	31	299	299	299
8	33	385	385	385
8	34	365	365	365
8	35	1127	1127	1127
9	36	426	426	426

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 11:58:59 GMT

Is this resolved or are you still looking for help on this?

Re: How to use RangeRum and Above

dotnetfan — Thu, 12 Sep 2019 12:03:26 GMT

Not solved. Could you please help me with above data source? Really appreciated!

Re: How to use RangeRum and Above

dotnetfan — Thu, 12 Sep 2019 12:08:27 GMT

Resolve, thanks!!

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 12:10:20 GMT

Seems to work okay... what is the issue in the attached screenshot?

Re: How to use RangeRum and Above

sunny_talwar — Thu, 12 Sep 2019 12:12:07 GMT

Not sure why neither of this work for you

RangeSum(Before(Sum(Value), 0, ColumnNo())) RangeSum(Above(Sum(Value), 0, RowNo()))

but this worked

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")

There might be more then what you provided which might be causing this... but I guess as long as it worked... we should be okay