topic Re: I want to simplify a rangesum expression in App Development

I want to simplify a rangesum expression

vjoshi2017 — Sat, 16 Nov 2024 03:19:26 GMT

I have put a slider in my dashboard which signifies months after my price changes.

To get the cumulative sum for my order quantity , I have put the below expression -

fabs(Pick(WildMatch($(POSTMONTH),0 , 1, 2, 3, 4, 5, 6, 7, 8, 8, 9, 10, 11,12,13,14,15,16,17,18),

Sum({<Post_months -= {"0"}>}ORDQTY_CL),
Sum({<Post_months = {"1"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17"}>}ORDQTY_CL),
Sum({<Post_months = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17", "18"}>}ORDQTY_CL)))

This can not be scaled after few months. Can I write this expression in a better way?

What I am doing here is getting the cumulative sum corresponding to slider variable value. I am trying to use rangesum but not been able to.

POSTMONTH is the variable used in slider.

Thanks,

Vivek

Re: I want to simplify a rangesum expression

Kashyap_R — Mon, 10 Feb 2020 09:07:51 GMT

Can u attach Sample qvf with sample data so that it will help to others to try and get back to u ASAP

thanks

Re: I want to simplify a rangesum expression

marcus_sommer — Mon, 10 Feb 2020 10:22:36 GMT

You may try something in this way:

Sum({<Post_months = {"<=$(POSTMONTH)"}>}ORDQTY_CL)

- Marcus

Re: I want to simplify a rangesum expression

Kashyap_R — Mon, 10 Feb 2020 10:28:22 GMT

Adding to @marcus_sommer

IF($(POSTMONTH)>0

Sum({<Post_months = {"<=$(POSTMONTH)"}>}ORDQTY_CL),Sum({<Post_months -= {"0"}>}ORDQTY_CL))

Thanks

Re: I want to simplify a rangesum expression

vjoshi2017 — Wed, 12 Feb 2020 13:00:57 GMT

Both the expression doesn't give me same value.

Re: I want to simplify a rangesum expression

marcus_sommer — Wed, 12 Feb 2020 13:26:33 GMT

Is any of them correct? I suggest to use them within a table-chart with this or that dimensions which should show where the differences come from and could be then further examined. Also keep an eye on the fact that my suggestion didn't handle the case of 0 - so you adjust them maybe in this way:

Sum({<Post_months = {">0<=$(POSTMONTH)"}>}ORDQTY_CL)

- Marcus