Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have a chart with 3 colums, period, product, sum(qty)
and one list box with period.
This work perfect, now need add a column whit the sum of qty of previus period for each product.
Any idea?
Thanks Regards
César Estrada
Hi, Thanks both, the formula that work for me is
= sum({<Period= {">=1(=min(Period))<=$(=max(Period)-1)"}> } qty)
Thanks Regards
Try
above(sum(qty))
may be like this,
Sum {<Period = {"$(=(MAX(Period)-1))"}>}qty)
Hi Renjith, when paste u formula suggested, on the expression, tell me "garbage after expression", i cant use u formula on a expression or is for another use
Thanks
Hi Robert,
I try for example, sum between 2014 jan to 2015 jan, for each product and show this in one column, and 2015 feb in another column.
When chose 201502 in the list box, sum only 201502, but de another sum is 0.
U can please make one example for me
Regards
César Estrada
Hi, Thanks both, the formula that work for me is
= sum({<Period= {">=1(=min(Period))<=$(=max(Period)-1)"}> } qty)
Thanks Regards