topic Re: help with set analysis expression in App Development

help with set analysis expression

ramanarayan — Mon, 04 Feb 2019 10:23:19 GMT

Hi Experts

Need help with an expression please.

In the chart named 'expression help' i have an expression which should give me the sum of demand + sum of demand where month = key + 1.

I expect to see the value as 350 for the month of Aug.

I tried to use set analysis but i dont get the desired output. Can someone help please

Somasundaram — Mon, 04 Feb 2019 10:40:07 GMT

Hi,,

Instead of Set Analysis, You can use Accumulate (in 2 steps)

agigliotti — Mon, 04 Feb 2019 10:53:17 GMT

let's try using:
rangesum( above( sum(Demand), 0, RowNo() ) )
as expression

ramanarayan — Mon, 04 Feb 2019 11:41:32 GMT

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

If you can please help modify would be great.

ramanarayan — Mon, 04 Feb 2019 11:42:31 GMT

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

If you can please help modify would be great.