populating values

[raadwiptec]

Hi All,

This is my scenario. Please suggest.

basically avgprice is getting calculated by front end expression.. now after 12th month.. 13th to 18th month it should populate the same avgprice as 12 th month until 18th..

secondly these avgprice values should also gets populated from the 12th month avgprice for neutalprice and midstockprice from 13 to 18th

year	month	price	avgprice	neutalprice	midstockprice
2015	18	33	23,91666667	23,91666667	23,91666667
2015	17	33	23,91666667	23,91666667	23,91666667
2015	16	33	23,91666667	23,91666667	23,91666667
2015	15	33	23,91666667	23,91666667	23,91666667
2015	14	33	23,91666667	23,91666667	23,91666667
2015	13	33	23,91666667	23,91666667	23,91666667
2015	12	33	23,91666667	23,91666667	23,91666667
2015	11	31	23,09090909	22	77
2015	10	22	22,3	34	6
2015	9	34	22,33333333	22	5
2015	8	11	20,875	33	4
2015	7	44	22,28571429	11	5
2015	6	77	18,66666667	44	6
2015	5	6	7	77	7
2015	4	5	7,25	88	88
2015	3	7	8	99	7
2015	2	8	8,5	44	65
2015	1	9	9	3	4

[sunny_talwar]

Here, look at this expression:

=If([Month of Stock] <= 12, If(Sum([Price Value]) > 0, RangeAvg(Above(Sum({<[Month of Stock] = >}[Price Value]), 0, RowNo()))), Above([Avg Price Expression]))

Here Avg Price Expression is the Expression Label and you need to change it to you expression label. It should turn blue when it matches your expression label.

[raadwiptec]

Hi Sunny,

How can I include this expression value into my QVD?

[sunny_talwar]

‌there is a post reload Trigger + Macro which can help you achieve that. But I think if you want to save the results in a QVD it would be advisable to do it in the script itself. I don't advise to use Macro + Trigger as it is not a very efficient solution.